[DERBY-3091] NullPointerException executing SYSCS_UTIL.SYSCS_IMPORT_TABLE when derby.language.logQueryPlan=true

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.2.1.6
• Fix Version/s: 10.3.1.4
• Component/s: SQL

Environment

------------------ Java Information ------------------
Java Version: 1.6.0_01
Java Vendor: Sun Microsystems Inc.
Java home: C:\Program Files\Java\jre1.6.0_01
Java classpath: C:\Program Files\Java\jdk1.6.0_01\db\lib\derby.jar;C:\Program F
iles\Java\jdk1.6.0_01\db\lib\derbytools.jar;.;C:\Program Files\Java\jre1.6.0_01\
lib\ext\QTJava.zip
OS name: Windows XP
OS architecture: x86
OS version: 5.1
Java user name: Chip
Java user home: C:\Documents and Settings\Chip
Java user dir: C:\Documents and Settings\Chip\Desktop
java.specification.name: Java Platform API Specification
java.specification.version: 1.6
--------- Derby Information --------
JRE - JDBC: Java SE 6 - JDBC 4.0
[C:\Program Files\Java\jdk1.6.0_01\db\lib\derby.jar] 10.2.1.7 - (453926)
[C:\Program Files\Java\jdk1.6.0_01\db\lib\derbytools.jar] 10.2.1.7 - (453926)

• Assignee: Unassigned
• Reporter: Chip Hartney
• Created: 27/Sep/07 17:51
• Updated: 21/Jan/11 17:50
• Resolved: 07/Jul/08 19:21

Description

Derby throws NullPointerException when executing an IMPORT if logging of query plans is turned on in the derby.properties file as in:
derby.language.logQueryPlan=true

If logging is turned off, the failure does not occur and the table is successfully loaded.

I am using the version of Derby that is provided with Java 6.

Java source code is:

Statement stmt = oCnxn.createStatement();
try

{ stmt.execute("CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE ('TEMP', 'ZJVTERMS', 'C:\DOCUME~1\Chip\LOCALS~1\Temp\20070724-124300-ZJVTERMS.dat',';','~',null, 1)"); }

finally

{ stmt.close(); }

Derby log output is:

2007-09-27 15:29:06.843 GMT Thread[AWT-EventQueue-0,6,main] (XID = 311121), (SESSIONID = 0), INSERT INTO "TEMP"."ZJVTERMS"("CODE", "TEXT") PROPERTIES insertMode=replace SELECT cast(COLUMN1 AS INTEGER) , COLUMN2 from new org.apache.derby.impl.load.Import('C:\DOCUME~1\Chip\LOCALS~1\Temp\20070724-124300-ZJVTERMS.dat',';','~',null, 2 ) AS importvti ******* Insert ResultSet using table locking:
deferred: false
insert mode: bulk insert
Rows inserted = 22
Indexes updated = 0
Execute Time = 0
Normalize ResultSet:
Number of opens = 1
Rows seen = 22
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
optimizer estimated row count: 10000.00
optimizer estimated cost: 100000.00

Source result set:
Project-Restrict ResultSet (2):
Number of opens = 1
Rows seen = 22
Rows filtered = 0
restriction = false
projection = true
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
restriction time (milliseconds) = 0
projection time (milliseconds) = 0
optimizer estimated row count: 10000.00
optimizer estimated cost: 100000.00

Source result set:
VTI ResultSet for org.apache.derby.impl.load.Import:
Number of opens = 1
Rows seen = 22
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
optimizer estimated row count: 10000.00
optimizer estimated cost: 100000.00

2007-09-27 15:29:06.875 GMT Thread[AWT-EventQueue-0,6,main] (XID = 311199), (SESSIONID = 0), (DATABASE = OrderEntryDB), (DRDAID = null), Cleanup action starting
2007-09-27 15:29:06.875 GMT Thread[AWT-EventQueue-0,6,main] (XID = 311199), (SESSIONID = 0), (DATABASE = OrderEntryDB), (DRDAID = null), Failed Statement is: null

java.lang.NullPointerException evaluating expression
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
...ref to stmt.execute(...) in my code here...

Issue Links

• relates to: DERBY-2353 intermittent NPEs during DELETE ops in a reasonably large transaction