db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carl-Erik Kopseng (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2639) Bulk data load utility should indicate when it is finished.
Date Fri, 23 Apr 2010 08:33:53 GMT

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

Carl-Erik Kopseng commented on DERBY-2639:

@Knut Anders Hatlen 
You are indeed right, Knut, as that explains the errors as well as fixes them. I never thought
I would be so glad to be proven wrong! I falsely assumed the con.close() would do what <code>DriverManager.getConnection("jdbc:derby:testdb;shutdown=true");
</code> does, but I was obviously mistaken. Maybe this will come in handy for someone
else someday. 

Tusen takk :)

> 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
>          Components: Store
>    Affects Versions:
>         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
>         Attachments: crashderby_src.zip, DerbyProblem.jar
> 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.

View raw message