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 "Christian Schmidt (JIRA)" <ji...@apache.org> on 2014/09/19 12:40:33 UTC
[jira] [Commented] (DERBY-6745) NPE,
SQLNonTransientConnectionException: No current connection
[ https://issues.apache.org/jira/browse/DERBY-6745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14140301#comment-14140301 ]
Christian Schmidt commented on DERBY-6745:
------------------------------------------
It seems to be working now.
I zipped the derby db once more now with 7zip and everything seems to be ok. The select statement worked.
Ziped DB-Size is 28MB now.
First I have zipped the derby db with windows zip. Ziped DB-Size was about 52MB. In both cases original DB Size is about 178MB.
With the windows zip engine select doesn't work.
Perhaps this comment can help some one else.
> 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)