[DERBY-5237] interrupting thread performing "create table" doesn't cause SQLException with sql state "08000"

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.8.1.2
• Component/s: SQL
• Environment: Windows 7, JDK 1.6.0_25
• Issue & fix info: Repro attached
• Bug behavior facts: Deviation from standard
• Assignee: Unassigned
• Reporter: Jim Newsham
• Created: 17/May/11 20:27
• Updated: 17/Jun/13 09:19
• Resolved: 17/May/11 23:12

Description

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.

Issue Links

• duplicates: DERBY-5233 Interrupt of create table or index (i.e. a container) will throw XSDF1 under NIO - connection survives