[
https://issues.apache.org/jira/browse/DERBY-6745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Christian Schmidt updated DERBY-6745:
-------------------------------------
Description:
I have generated a local derby database on hdd. When I submit a select
statement to this database everything is ok. When using this database as
readonly jar in classpath and using the same statement I am getting the
following exceptions ...
I do some more tests to get more information. The two columns I could not
select sucessfully are foreign key columns. Hope this could help you a bit.
!ENTRY org.eclipse.datatools.sqltools.editor.core 4 0 2014-09-19 10:56:46.364
!MESSAGE Editor core plugin internal error
!STACK 0
java.sql.SQLNonTransientConnectionException: No current connection.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.getAutoCommit(Unknown
Source)
at
org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable.initConnection(ResultSupportRunnable.java:314)
at
org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable.run(ResultSupportRunnable.java:112)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: ERROR 08003: No current connection.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 10 more
!ENTRY org.eclipse.datatools.sqltools.result 4 0 2014-09-19 10:57:31.615
!MESSAGE No resource is associated with key
"ResultsViewAPI_append_resultset_error".
!ENTRY org.eclipse.datatools.sqltools.result 4 0 2014-09-19 10:57:31.630
!MESSAGE ResultsViewAPI_append_resultset_error possible args: {0}, {1}, {2}, {3}
!STACK 0
java.sql.SQLException: Java exception: ': java.lang.NullPointerException'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
at
org.eclipse.datatools.sqltools.result.ResultSetObject.<init>(ResultSetObject.java:145)
at
org.eclipse.datatools.sqltools.result.internal.model.ResultInstanceFactory.createResultSetObject(ResultInstanceFactory.java:79)
at
org.eclipse.datatools.sqltools.result.internal.model.ResultInstance.moreResultSet(ResultInstance.java:127)
at
org.eclipse.datatools.sqltools.result.ResultsViewAPI.appendResultSet(ResultsViewAPI.java:353)
at
org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable.loopThroughResults(ResultSupportRunnable.java:572)
at
org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable.handleSuccess(ResultSupportRunnable.java:419)
at
org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable$HandleSuccessJob.run(ResultSupportRunnable.java:302)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 19 more
Caused by: java.lang.NullPointerException
at
org.apache.derby.impl.store.access.btree.ControlRow.getControlRowForPage(Unknown
Source)
at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown
Source)
at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.ControlRow.getRightSibling(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.BTreeScan.positionAtNextPage(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.BTreeScan.fetchNextGroup(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown
Source)
... 10 more
was:
I have generated a local derby database on hdd. When I submit a select
statement to this database everything is ok. When using this database as
readonly jar in classpath and using the same statement I am getting the
following exceptions ...
!ENTRY org.eclipse.datatools.sqltools.editor.core 4 0 2014-09-19 10:56:46.364
!MESSAGE Editor core plugin internal error
!STACK 0
java.sql.SQLNonTransientConnectionException: No current connection.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.getAutoCommit(Unknown
Source)
at
org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable.initConnection(ResultSupportRunnable.java:314)
at
org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable.run(ResultSupportRunnable.java:112)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: ERROR 08003: No current connection.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 10 more
!ENTRY org.eclipse.datatools.sqltools.result 4 0 2014-09-19 10:57:31.615
!MESSAGE No resource is associated with key
"ResultsViewAPI_append_resultset_error".
!ENTRY org.eclipse.datatools.sqltools.result 4 0 2014-09-19 10:57:31.630
!MESSAGE ResultsViewAPI_append_resultset_error possible args: {0}, {1}, {2}, {3}
!STACK 0
java.sql.SQLException: Java exception: ': java.lang.NullPointerException'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
at
org.eclipse.datatools.sqltools.result.ResultSetObject.<init>(ResultSetObject.java:145)
at
org.eclipse.datatools.sqltools.result.internal.model.ResultInstanceFactory.createResultSetObject(ResultInstanceFactory.java:79)
at
org.eclipse.datatools.sqltools.result.internal.model.ResultInstance.moreResultSet(ResultInstance.java:127)
at
org.eclipse.datatools.sqltools.result.ResultsViewAPI.appendResultSet(ResultsViewAPI.java:353)
at
org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable.loopThroughResults(ResultSupportRunnable.java:572)
at
org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable.handleSuccess(ResultSupportRunnable.java:419)
at
org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable$HandleSuccessJob.run(ResultSupportRunnable.java:302)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 19 more
Caused by: java.lang.NullPointerException
at
org.apache.derby.impl.store.access.btree.ControlRow.getControlRowForPage(Unknown
Source)
at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown
Source)
at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.ControlRow.getRightSibling(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.BTreeScan.positionAtNextPage(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown
Source)
at
org.apache.derby.impl.store.access.btree.BTreeScan.fetchNextGroup(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown
Source)
at
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown
Source)
... 10 more
> NPE, SQLNonTransientConnectionException: No current connection
> --------------------------------------------------------------
>
> Key: DERBY-6745
> URL: https://issues.apache.org/jira/browse/DERBY-6745
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.10.2.0, 10.11.1.1
> Environment: Windows 7, 64bit, Java jdk 1.7.0_60, 1.8.0_20
> Reporter: Christian Schmidt
>
> I have generated a local derby database on hdd. When I submit a select
> statement to this database everything is ok. When using this database as
> readonly jar in classpath and using the same statement I am getting the
> following exceptions ...
> I do some more tests to get more information. The two columns I could not
> select sucessfully are foreign key columns. Hope this could help you a bit.
> !ENTRY org.eclipse.datatools.sqltools.editor.core 4 0 2014-09-19 10:56:46.364
> !MESSAGE Editor core plugin internal error
> !STACK 0
> java.sql.SQLNonTransientConnectionException: No current connection.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.getAutoCommit(Unknown
> Source)
> at
> org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable.initConnection(ResultSupportRunnable.java:314)
> at
> org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable.run(ResultSupportRunnable.java:112)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
> Caused by: ERROR 08003: No current connection.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> ... 10 more
> !ENTRY org.eclipse.datatools.sqltools.result 4 0 2014-09-19 10:57:31.615
> !MESSAGE No resource is associated with key
> "ResultsViewAPI_append_resultset_error".
> !ENTRY org.eclipse.datatools.sqltools.result 4 0 2014-09-19 10:57:31.630
> !MESSAGE ResultsViewAPI_append_resultset_error possible args: {0}, {1}, {2},
> {3}
> !STACK 0
> java.sql.SQLException: Java exception: ': java.lang.NullPointerException'.
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
> at
> org.eclipse.datatools.sqltools.result.ResultSetObject.<init>(ResultSetObject.java:145)
> at
> org.eclipse.datatools.sqltools.result.internal.model.ResultInstanceFactory.createResultSetObject(ResultInstanceFactory.java:79)
> at
> org.eclipse.datatools.sqltools.result.internal.model.ResultInstance.moreResultSet(ResultInstance.java:127)
> at
> org.eclipse.datatools.sqltools.result.ResultsViewAPI.appendResultSet(ResultsViewAPI.java:353)
> at
> org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable.loopThroughResults(ResultSupportRunnable.java:572)
> at
> org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable.handleSuccess(ResultSupportRunnable.java:419)
> at
> org.eclipse.datatools.sqltools.editor.core.result.ResultSupportRunnable$HandleSuccessJob.run(ResultSupportRunnable.java:302)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
> Caused by: ERROR XJ001: Java exception: ': java.lang.NullPointerException'.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> ... 19 more
> Caused by: java.lang.NullPointerException
> at
> org.apache.derby.impl.store.access.btree.ControlRow.getControlRowForPage(Unknown
> Source)
> at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown
> Source)
> at org.apache.derby.impl.store.access.btree.ControlRow.get(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.btree.ControlRow.getRightSibling(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.btree.BTreeScan.positionAtNextPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.btree.BTreeScan.fetchNextGroup(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown
> Source)
> at
> org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown
> Source)
> ... 10 more
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
