[
https://issues.apache.org/jira/browse/DERBY-3091?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12531671
]
Bryan Pendleton commented on DERBY-3091:
----------------------------------------
It fails for me in 10.2.2.1. The stack trace I get is:
java.lang.NullPointerException
at
org.apache.derby.impl.sql.execute.NoRowsResultSetImpl.finish(NoRowsResultSetImpl.java:410)
at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1224)
at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:585)
at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:517)
at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:323)
at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:529)
at
org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:371)
at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:269)
at org.apache.derby.impl.tools.ij.Main.go(Main.java:204)
at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:170)
at org.apache.derby.impl.tools.ij.Main14.main(Main14.java:56)
at org.apache.derby.tools.ij.main(ij.java:71)
Cleanup action completed
Line 410 of NoRowsResultSetImpl.java is the istream.printlnWithHeader call that
follows:
if (istream != null)
{
istream.printlnWithHeader(LanguageConnectionContext.xidStr +
lcc.getTransactionExecute().getTransactionIdString() +
"), " +
LanguageConnectionContext.lccStr +
lcc.getInstanceNumber() +
"), " +
lcc.getRunTimeStatisticsObject().getStatementText() + " ******* " +
lcc.getRunTimeStatisticsObject().getStatementExecutionPlanText());
}
Unfortunately, this particular "if" statement has not changed in 10.3 or in the
trunk,
so I'm not really sure what change fixed this problem.
> 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
> Attachments: 20070724-124300-ZJVTERMS.dat
>
>
> 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.
