[DERBY-2639] Bulk data load utility should indicate when it is finished.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.2.2.0
• Component/s: Store
• Labels: derby_triage10_8
• Environment: Java Version: 1.5.0_06; Java Vendor: Sun Microsystems Inc.; OS name: Windows XP; IDE: Eclipse; Derby: 10.2.2, running Embedded
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Patty Parker
• Created: 11/May/07 21:17
• Updated: 14/Feb/11 19:21

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.