test(org.apache.jdo.tck.query.WhiteSpaceIsACharacterAndIgnored: javax.jdo.JDODataStoreException: Cannot get long result : param = 2

• Key: JDO-90
• Type: Bug
• Status: Closed
• Resolution: Fixed
• Priority: Major
• Assignee: AJSoft
• Reporter: Michelle Caisse
• Component/s: tck2
• Fix Version/s: JDO 2 beta

Description

test(org.apache.jdo.tck.query.WhiteSpaceIsACharacterAndIgnored)javax.jdo.JDODataStoreException: Cannot get long result : param = 2
at org.jpox.store.rdbms.mapping.BigIntRDBMSMapping.getLong(BigIntRDBMSMapping.java:130)
at org.jpox.store.mapping.SingleFieldMapping.getLong(SingleFieldMapping.java:200)
at org.jpox.store.rdbms.fieldmanager.ResultSetGetter.fetchLongField(ResultSetGetter.java:69)
at org.jpox.state.StateManagerImpl.replacingLongField(StateManagerImpl.java:2529)
at org.apache.jdo.tck.pc.mylib.PCPoint.jdoReplaceField(PCPoint.java)
at org.apache.jdo.tck.pc.mylib.PCPoint.jdoReplaceFields(PCPoint.java)
at org.jpox.state.StateManagerImpl.replaceFields(StateManagerImpl.java:2759)
at org.jpox.store.query.PersistentIDROF$1.fetchFields(PersistentIDROF.java:201)
at org.jpox.state.StateManagerImpl.<init>(StateManagerImpl.java:432)
at org.jpox.AbstractPersistenceManager.getObjectByAID(AbstractPersistenceManager.java:2075)
at org.jpox.store.query.PersistentIDROF.getObjectByAID(PersistentIDROF.java:196)
at org.jpox.store.query.PersistentIDROF.getObject(PersistentIDROF.java:169)
at org.jpox.store.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:101)
at org.jpox.store.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:91)
at org.jpox.store.query.ForwardQueryResult.size(ForwardQueryResult.java:332)
at org.apache.jdo.tck.query.QueryTest.checkQueryResultWithoutOrder(QueryTest.java:369)
at org.apache.jdo.tck.query.WhiteSpaceIsACharacterAndIgnored.runTestWhiteSpaceIsACharacterAndIgnored01(WhiteSpaceIsACharacterAndIgnored.java:120)
at org.apache.jdo.tck.query.WhiteSpaceIsACharacterAndIgnored.test(WhiteSpaceIsACharacterAndIgnored.java:65)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:203)
at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:128)
at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:106)
NestedThrowablesStackTrace:
SQL Exception: ResultSet not open, operation 'getXXX' not permitted. Verify that autocommit is OFF.
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(ConnectionChild.java)
at org.apache.derby.impl.jdbc.EmbedResultSet.checkIfClosed(EmbedResultSet.java)
at org.apache.derby.impl.jdbc.EmbedResultSet.getColumn(EmbedResultSet.java)
at org.apache.derby.impl.jdbc.EmbedResultSet.getLong(EmbedResultSet.java)
at com.mchange.v2.c3p0.impl.NewProxyResultSet.getLong(NewProxyResultSet.java:385)
at org.jpox.store.rdbms.mapping.BigIntRDBMSMapping.getLong(BigIntRDBMSMapping.java:121)
at org.jpox.store.mapping.SingleFieldMapping.getLong(SingleFieldMapping.java:200)
at org.jpox.store.rdbms.fieldmanager.ResultSetGetter.fetchLongField(ResultSetGetter.java:69)
at org.jpox.state.StateManagerImpl.replacingLongField(StateManagerImpl.java:2529)
at org.apache.jdo.tck.pc.mylib.PCPoint.jdoReplaceField(PCPoint.java)
at org.apache.jdo.tck.pc.mylib.PCPoint.jdoReplaceFields(PCPoint.java)
at org.jpox.state.StateManagerImpl.replaceFields(StateManagerImpl.java:2759)
at org.jpox.store.query.PersistentIDROF$1.fetchFields(PersistentIDROF.java:201)
at org.jpox.state.StateManagerImpl.<init>(StateManagerImpl.java:432)
at org.jpox.AbstractPersistenceManager.getObjectByAID(AbstractPersistenceManager.java:2075)
at org.jpox.store.query.PersistentIDROF.getObjectByAID(PersistentIDROF.java:196)
at org.jpox.store.query.PersistentIDROF.getObject(PersistentIDROF.java:169)
at org.jpox.store.query.ForwardQueryResult.nextResultSetElement(ForwardQueryResult.java:101)
at org.jpox.store.query.ForwardQueryResult.advanceToEndOfResultSet(ForwardQueryResult.java:91)
at org.jpox.store.query.ForwardQueryResult.size(ForwardQueryResult.java:332)
at org.apache.jdo.tck.query.QueryTest.checkQueryResultWithoutOrder(QueryTest.java:369)
at org.apache.jdo.tck.query.WhiteSpaceIsACharacterAndIgnored.runTestWhiteSpaceIsACharacterAndIgnored01(WhiteSpaceIsACharacterAndIgnored.java:120)
at org.apache.jdo.tck.query.WhiteSpaceIsACharacterAndIgnored.test(WhiteSpaceIsACharacterAndIgnored.java:65)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:203)
at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:128)
at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:106)

Comments

[Craig Russell]

This appears to be a bug in JPOX where the result of a query is retrieved by calling the size() method on the Collection result.

[Andy Jefferson]

This is now fixed in JPOX CVS - was actually to do with calling size() on the query result *after* the close the transaction.
Will be in a JPOX build dated 26/09/2005 or later. Can someone with the necessary permissions please confirm it and close the issue.

[Michael Bouschen]

Reopened to set the Fix Version/s field to JDO 2 beta.