db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2639) Bulk data load utility should indicate when it is finished.
Date Fri, 11 May 2007 23:54:15 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12495208
] 

Daniel John Debrunner commented on DERBY-2639:
----------------------------------------------

There seem to be a couple of bugs here:
  1) the procedure should not return before it has finished.
  2) the container not found exceptions should not occur regardless of if the load has finished
or not.

> Bulk data load utility should indicate when it is finished.
> -----------------------------------------------------------
>
>                 Key: DERBY-2639
>                 URL: https://issues.apache.org/jira/browse/DERBY-2639
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.2.2.0
>         Environment: Java Version:    1.5.0_06
> Java Vendor:     Sun Microsystems Inc.
> OS name:         Windows XP
> IDE:  Eclipse
> Derby:  10.2.2,  running Embedded
>            Reporter: Patty Parker
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message