Affects Version/s: 10.2.2.0
Fix Version/s: None
Environment:Java Version: 1.5.0_06
Java Vendor: Sun Microsystems Inc.
OS name: Windows XP
Derby: 10.2.2, running Embedded
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.