1. Derby
  2. DERBY-2639

Bulk data load utility should indicate when it is finished.


    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s:
    • Fix Version/s: None
    • Component/s: Store
    • 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:


      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.

        7 kB
        Carl-Erik Kopseng
      2. DerbyProblem.jar
        57 kB
        Patty Parker


        Patty Parker created issue -
        Daniel John Debrunner made changes -
        Field Original Value New Value
        Component/s Store [ 11412 ]
        Patty Parker made changes -
        Attachment DerbyProblem.jar [ 12357487 ]
        Carl-Erik Kopseng made changes -
        Attachment [ 12442637 ]
        Mike Matrigali made changes -
        Issue Type Bug [ 1 ] Improvement [ 4 ]
        Labels derby_triage10_8
        Urgency Normal
        Gavin made changes -
        Workflow jira [ 12403766 ] Default workflow, editable Closed status [ 12801542 ]


          • Assignee:
            Patty Parker
          • Votes:
            1 Vote for this issue
            1 Start watching this issue


            • Created: