Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
10.2.2.0
-
None
-
Java Version: 1.5.0_06
Java Vendor: Sun Microsystems Inc.
OS name: Windows XP
IDE: Eclipse
Derby: 10.2.2, running Embedded
-
Normal
Description
The bulk load CALL SYSCS_UTIL.SYSCS_IMPORT_DATA appears to be finished (i.e. the statement returns), but it is not entirely
finishing before I try to query the table it is populating. I would expect to get a locking exception, or something of that nature, but
the error I get is either SQLERROR XSCB1 or SQLERROR XSCBH1, Container <containerName> not found. It has given me both at different times.
An improvement I would suggest is having SYSCS_UTIL.SYSCS_IMPORT_DATA indicate when it is done loading. As it stands now, the thread I have running it finishes before the utility finishes, and I have no elegant way of knowing when the load is done, other than trying to use the table and trapping for I listed above.
For more information, please see the post "SQL Exception: Container xxx not found" in derby-user mail list.