db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chip Hartney (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-3091) NullPointerException executing SYSCS_UTIL.SYSCS_IMPORT_TABLE when derby.language.logQueryPlan=true
Date Thu, 27 Sep 2007 17:51:50 GMT
NullPointerException executing SYSCS_UTIL.SYSCS_IMPORT_TABLE when derby.language.logQueryPlan=true
--------------------------------------------------------------------------------------------------

                 Key: DERBY-3091
                 URL: https://issues.apache.org/jira/browse/DERBY-3091
             Project: Derby
          Issue Type: Bug
    Affects Versions: 10.2.1.6
         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)

            Reporter: Chip Hartney


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...


-- 
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