You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-dev@db.apache.org by "Michelle Caisse (JIRA)" <ji...@apache.org> on 2005/09/22 00:14:38 UTC

[jira] Closed: (JDO-121) 'ADPT_PK_IDX' is not a column in table or VTI 'APPLICATIONIDENTITY0.COLLECTION_OF_OBJECT1'

     [ http://issues.apache.org/jira/browse/JDO-121?page=all ]
     
Michelle Caisse closed JDO-121:
-------------------------------

    Resolution: Fixed

<order> to allow duplicates works.  Test errs/fails for other reasons now.

> '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