db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christian Schmidt (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-6745) NPE, SQLNonTransientConnectionException: No current connection
Date Fri, 19 Sep 2014 09:51:34 GMT

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

Mime
View raw message