db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5237) interrupting thread performing "create table" doesn't cause SQLException with sql state "08000"
Date Wed, 18 May 2011 16:56:47 GMT

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

Dag H. Wanvik commented on DERBY-5237:
--------------------------------------

Thanks for testing the new feature, Jim. If you would like to see this fixed in an update
release, please give the issue a vote!
Meanwhile, you can work around this by catching the exception with SQL state XSDF1 and retrying
the create, cf the repro code attached to DERBY-5233.


> interrupting thread performing "create table" doesn't cause SQLException with sql state
"08000"
> -----------------------------------------------------------------------------------------------
>
>                 Key: DERBY-5237
>                 URL: https://issues.apache.org/jira/browse/DERBY-5237
>             Project: Derby
>          Issue Type: Bug
>    Affects Versions: 10.8.1.2
>         Environment: Windows 7, JDK 1.6.0_25
>            Reporter: Jim Newsham
>         Attachments: DerbyInterruptTest.java
>
>
> We would like to take advantage of the recent Derby enhancement for handling thread interruption.
 http://db.apache.org/derby/docs/dev/devguide/devguide-single.html, section "Working with
database threads in an embedded environment" states that in the case of exception, the calling
code should receive a SQLException with code 08000.  In my testing, this appears to work for
sql "insert" statements, but not for sql "create table" statements.  This is an issue for
us since database tables are created dynamically over the course of the application's normal
operation.
> Junit test repro to follow.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message