[ http://issues.apache.org/jira/browse/JDO-121?page=all ] Michael Bouschen reopened JDO-121: ----------------------------------
> 'ADPT_PK_IDX' is not a column in table or VTI > 'APPLICATIONIDENTITY0.COLLECTION_OF_OBJECT1' > ------------------------------------------------------------------------------------------ > > Key: JDO-121 > URL: http://issues.apache.org/jira/browse/JDO-121 > Project: JDO > Type: Bug > Components: tck20 > Reporter: Michelle Caisse > Assignee: Erik Bengtson > > JPOX changes name of ID column in join tables for collection of objects > field. Looking for a pk? > test(org.apache.jdo.tck.models.fieldtypes.TestCollectionCollections)javax.jdo.JDODataStoreException: > Add request failed : INSERT INTO applicationidentity0.COLLECTION_OF_OBJECT1 > (IDENTIFIER,ADPT_PK_IDX,INTVAL,STRINGVAL) VALUES (?,?,?,?) > at > org.jpox.store.rdbms.scostore.NormalSetStore.add(NormalSetStore.java:578) > at org.jpox.sco.SCOUtils.updateStoreWithCollection(SCOUtils.java:461) > at > org.jpox.store.mapping.container.CollectionMapping.postUpdate(CollectionMapping.java:279) > at > org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:266) > at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:1834) > at org.jpox.store.StoreManager.update(StoreManager.java:768) > at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4042) > at > org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:2932) > at org.jpox.NonmanagedTransaction.commit(NonmanagedTransaction.java:432) > at > org.apache.jdo.tck.models.fieldtypes.TestCollectionCollections.runTest(TestCollectionCollections.java:97) > at > org.apache.jdo.tck.models.fieldtypes.TestCollectionCollections.test(TestCollectionCollections.java:69) > 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:197) > at > org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:128) > at > org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:106) > NestedThrowablesStackTrace: > ERROR 42X14: 'ADPT_PK_IDX' is not a column in table or VTI > 'APPLICATIONIDENTITY0.COLLECTION_OF_OBJECT1'. > at > org.apache.derby.iapi.error.StandardException.newException(StandardException.java) > at > org.apache.derby.impl.sql.compile.ResultColumn.bindResultColumnByName(ResultColumn.java) > at > org.apache.derby.impl.sql.compile.ResultColumnList.bindResultColumnsByName(ResultColumnList.java) > at org.apache.derby.impl.sql.compile.InsertNode.bind(InsertNode.java) > at > org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java) > at > org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java) > at > org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java) > at > org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java) > at > org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java) > at > org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java) > at > com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:190) > at > org.jpox.store.rdbms.scostore.NormalSetStore.add(NormalSetStore.java:538) > at org.jpox.sco.SCOUtils.updateStoreWithCollection(SCOUtils.java:461) > at > org.jpox.store.mapping.container.CollectionMapping.postUpdate(CollectionMapping.java:279) > at > org.jpox.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:266) > at org.jpox.store.rdbms.table.ClassTable.update(ClassTable.java:1834) > at org.jpox.store.StoreManager.update(StoreManager.java:768) > at org.jpox.state.StateManagerImpl.flush(StateManagerImpl.java:4042) > at > org.jpox.AbstractPersistenceManager.flush(AbstractPersistenceManager.java:2932) > at org.jpox.NonmanagedTransaction.commit(NonmanagedTransaction.java:432) > at > org.apache.jdo.tck.models.fieldtypes.TestCollectionCollections.runTest(TestCollectionCollections.java:97) > at > org.apache.jdo.tck.models.fieldtypes.TestCollectionCollections.test(TestCollectionCollections.java:69) > 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:197) > at > org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:128) > at > org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:106) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
