Derby
  1. Derby
  2. DERBY-2639

Bulk data load utility should indicate when it is finished.

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 10.2.2.0
    • 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:
      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.

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

        Activity

        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 crashderby_src.zip [ 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 ]

          People

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

            Dates

            • Created:
              Updated:

              Development