You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Bryan Pendleton (JIRA)" <ji...@apache.org> on 2007/10/01 06:03:50 UTC
[jira] Commented: (DERBY-3091) NullPointerException executing
SYSCS_UTIL.SYSCS_IMPORT_TABLE when derby.language.logQueryPlan=true
[ https://issues.apache.org/jira/browse/DERBY-3091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12531405 ]
Bryan Pendleton commented on DERBY-3091:
----------------------------------------
I tried a simple call to SYSCS_IMPORT_TABLE with -Dderby.language.logQueryPlan,
and did not get a NullPointerException.
The rows from my text file were successfully imported, and a query plan for the
import processing was printed to my derby.log.
Can you provide an ij script (with the table definition and the import statement)
and the corresponding data file, which reproduces the problem in your environment?
Thanks!
> 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.