db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Manoranjan Sahu (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4794) NPE at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.finishAndRTS
Date Tue, 07 Sep 2010 16:24:33 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Manoranjan Sahu updated DERBY-4794:
-----------------------------------


One of the scenario where I see the issue is when I use an JPA entity(A) which has one to
many mapping with other JPA entity(B).
When I try to A.Bcollections(), the derby's select fires and throws the following error.
I am providing the part of exception which will be useful to you.

Equally severe exception raised during cleanup (ignored) null
java.lang.NullPointerException
    at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.finishAndRTS(Unknown Source)
    at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.finish(Unknown Source)
    at org.apache.derby.impl.sql.execute.BaseActivation.close(Unknown Source)
    at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.cleanupOnError(Unknown
Source)
    at org.apache.derby.iapi.services.context.ContextManager.cleanupOnError(Unknown Source)
    at org.apache.derby.impl.jdbc.TransactionResourceImpl.cleanupOnError(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.EmbedStatement.executeStatement(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source)
    at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:726)
    at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:501)
    at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:452)
    at oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:473)
    at oracle.toplink.essentials.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:152)
    at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
    at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:214)
    at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectOneRow(DatasourceCallQueryMechanism.java:635)
    at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectOneRowFromTable(ExpressionQueryMechanism.java:2453)
    at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectOneRow(ExpressionQueryMechanism.java:2428)
    at oracle.toplink.essentials.queryframework.ReadObjectQuery.executeObjectLevelReadQuery(ReadObjectQuery.java:365)
    at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:724)
    at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:628)
    at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:692)
    at oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:1834)
    at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:952)
    at oracle.toplink.essentials.internal.indirection.NoIndirectionPolicy.valueFromQuery(NoIndirectionPolicy.java:250)
    at oracle.toplink.essentials.mappings.ForeignReferenceMapping.valueFromRowInternal(ForeignReferenceMapping.java:1001)
    at oracle.toplink.essentials.mappings.OneToOneMapping.valueFromRowInternal(OneToOneMapping.java:1065)
    at oracle.toplink.essentials.mappings.ForeignReferenceMapping.valueFromRow(ForeignReferenceMapping.java:938)
    at oracle.toplink.essentials.mappings.DatabaseMapping.readFromRowIntoObject(DatabaseMapping.java:1022)
    at oracle.toplink.essentials.internal.descriptors.ObjectBuilder.buildAttributesIntoObject(ObjectBuilder.java:281)
    at oracle.toplink.essentials.internal.descriptors.ObjectBuilder.buildObject(ObjectBuilder.java:530)
    at oracle.toplink.essentials.internal.descriptors.ObjectBuilder.buildObject(ObjectBuilder.java:389)
    at oracle.toplink.essentials.internal.descriptors.ObjectBuilder.buildObjectsInto(ObjectBuilder.java:660)
    at oracle.toplink.essentials.internal.queryframework.DatabaseQueryMechanism.buildObjectsFromRows(DatabaseQueryMechanism.java:197)
    at oracle.toplink.essentials.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:348)
    at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:724)
    at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:628)
    at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:692)
    at oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:1834)
    at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:952)
    at oracle.toplink.essentials.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:101)
    at oracle.toplink.essentials.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:91)
    at oracle.toplink.essentials.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:105)
    at oracle.toplink.essentials.internal.indirection.UnitOfWorkValueHolder.instantiateImpl(UnitOfWorkValueHolder.java:175)
    at oracle.toplink.essentials.internal.indirection.UnitOfWorkValueHolder.instantiate(UnitOfWorkValueHolder.java:247)
    at oracle.toplink.essentials.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:105)
    at oracle.toplink.essentials.indirection.IndirectList.buildDelegate(IndirectList.java:208)
    at oracle.toplink.essentials.indirection.IndirectList.getDelegate(IndirectList.java:330)
    at oracle.toplink.essentials.indirection.IndirectList.size(IndirectList.java:655)

However this does not happen always.

Besides, Could you please suggest me the appropriate derby version I need to use in production
system.
I saw the following versions

----------------------

    * 10.5.3.0 (August 21, 2009 / SVN 802917)
    * 10.5.1.1 (April 28, 2009 / SVN 764942)
    * 10.4.2.0 (September 5, 2008 / SVN 689064)
    * 10.3.3.0 (May 12, 2008 / SVN 652961)
    * 10.4.1.3 (April 24, 2008 / SVN 648739)
    * 10.2.2.0 (Dec 12, 2006 / SVN 485682)
    * 10.2.1.6 (Oct 02, 2006 / SVN 452058)
    * 10.1.3.1 (Jun 30, 2006 / SVN 417277)
    * 10.1.2.1 (Nov 18, 2005 / SVN 330608)
    * 10.1.1.0 (Aug 3, 2005 / SVN 208786)
    * ------------------------------------------------------------

I am not sure my version 561794 is too old(bad?) to use in production.

Any help is welcome.


PS:- I use toplink as my persistence provider.

> NPE at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.finishAndRTS 
> ------------------------------------------------------------------------------
>
>                 Key: DERBY-4794
>                 URL: https://issues.apache.org/jira/browse/DERBY-4794
>             Project: Derby
>          Issue Type: Bug
>          Components: Miscellaneous
>         Environment: Derby version info -- as seen in MANIFEST.MF
> Manifest-Version: 1.0
> Ant-Version: Apache Ant 1.6.5
> Created-By: 1.4.2_12-b03 (Sun Microsystems Inc.)
> Bundle-Vendor: Apache Software Foundation
> Bundle-Name: Apache Derby 10.3
> Bundle-Version: 10.3.1000004.561794
> Sealed: true
>            Reporter: Manoranjan Sahu
>
> Derby is throwing NPE randomly while executing simple sql statements. 
> Stack trace in derby.log
> Caused by: java.sql.SQLException: Java exception: ': java.lang.NullPointerException'.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(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.EmbedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source)
> 	at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:726)
> 	at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:501)
> 	... 58 more
> Caused by: java.sql.SQLException: Java exception: ': java.lang.NullPointerException'.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
> 	... 70 more
> Caused by: java.lang.NullPointerException
> 	at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.finishAndRTS(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.finish(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.BaseActivation.close(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericActivationHolder.execute(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
> 	... 63 more
> It is noticed that this issue is happening randomly , during selects and inserts. I did
not find any quick reproduction steps for it.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message