[ http://issues.apache.org/jira/browse/JDO-143?page=all ]

Michelle Caisse reassigned JDO-143:
-----------------------------------

Assign To: Michelle Caisse  (was: Erik Bengtson)

> ERROR 23503: INSERT on table 'COLLECTION_OF_SIMPLE_CLASS3' caused a violat
ion of foreign key constraint
> --------------------------------------------------------------------------
-----------------------------
>
>          Key: JDO-143
>          URL: http://issues.apache.org/jira/browse/JDO-143
>      Project: JDO
>         Type: Bug
>   Components: tck20
>     Reporter: Michelle Caisse
>     Assignee: Michelle Caisse

>
>     [java] 1) test(org.apache.jdo.tck.models.fieldtypes.TestCollectionCollecti
ons)javax.jdo.JDODataStoreException: Add request failed : INSERT INTO applicationide
ntity0.COLLECTION_OF_SIMPLE_CLASS3  (IDENTIFIER,ALLOW_DUPLICATES,SIMPCLSREF)
 VALUES (
?,?,?)

>     [java]      at org.jpox.store.rdbms.scostore.NormalSetStore.add(No
rmalSetStore.java:672)
>     [java]      at org.jpox.sco.SCOUtils.updateStoreWithCollection(SCO
Utils.java:489)
>     [java]      at org.jpox.store.mapping.container.CollectionMapping.
postUpdate(CollectionMapping.java:279)
>     [java]      at org.jpox.store.rdbms.request.UpdateRequest.execute(
UpdateRequest.java:266)
>     [java]      at org.jpox.store.rdbms.table.ClassTable.update(ClassT
able.java:1838)
>     [java]      at org.jpox.store.StoreManager.update(StoreManager.jav
a:782)
>     [java]      at org.jpox.state.StateManagerImpl.flush(StateManagerI
mpl.java:4298)
>     [java]      at org.jpox.state.StateManagerImpl.runReachability(Sta
teManagerImpl.java:3102)
>     [java]      at org.jpox.AbstractPersistenceManager.preCommit(Abstr
actPersistenceManager.java:3049)
>     [java]      at org.jpox.NonmanagedTransaction.commit(NonmanagedTra
nsaction.java:419)
>     [java]      at org.apache.jdo.tck.models.fieldtypes.TestCollection
Collections.runTest(TestCollectionCollections.java:97)
>     [java]      at org.apache.jdo.tck.models.fieldtypes.TestCollection
Collections.test(TestCollectionCollections.java:69)
>     [java]      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
 Method)
>     [java]      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeM
ethodAccessorImpl.java:39)
>     [java]      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Del
egatingMethodAccessorImpl.java:25)
>     [java]      at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:2
04)
>     [java]      at org.apache.jdo.tck.util.BatchTestRunner.start(Batch
TestRunner.java:115)
>     [java]      at org.apache.jdo.tck.util.BatchTestRunner.main(BatchT
estRunner.java:93)
>     [java] NestedThrowablesStackTrace:
>     [java] ERROR 23503: INSERT on table 'COLLECTION_OF_SIMPLE_CLASS3' 
caused a violation of foreign key constraint SQL050921005031671' for key (11
27341751473).  The statement has been rolled back.
>     [java]      at org.apache.derby.iapi.error.StandardException.newEx
ception(Unknown Source)
>     [java]      at org.apache.derby.impl.sql.execute.ForeignKeyRICheck
er.doCheck(Unknown Source)
>     [java]      at org.apache.derby.impl.sql.execute.GenericRIChecker.
doCheck(Unknown Source)
>     [java]      at org.apache.derby.impl.sql.execute.RISetChecker.doFK
Check(Unknown Source)
>     [java]      at org.apache.derby.impl.sql.execute.InsertResultSet.n
ormalInsertCore(Unknown Source)
>     [java]      at org.apache.derby.impl.sql.execute.InsertResultSet.o
pen(Unknown Source)
>     [java]      at org.apache.derby.impl.sql.GenericPreparedStatement.
execute(Unknown Source)
>     [java]      at org.apache.derby.impl.jdbc.EmbedStatement.executeSt
atement(Unknown Source)
>     [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.e
xecuteStatement(Unknown Source)
>     [java]      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.e
xecuteUpdate(Unknown Source)
>     [java]      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.
executeUpdate(NewProxyPreparedStatement.java:105)
>     [java]      at org.jpox.store.rdbms.scostore.BaseContainerStore.ex
ecuteUpdate(BaseContainerStore.java:97)
>     [java]      at org.jpox.store.rdbms.scostore.NormalSetStore.add(No
rmalSetStore.java:654)
>     [java]      at org.jpox.sco.SCOUtils.updateStoreWithCollection(SCO
Utils.java:489)
>     [java]      at org.jpox.store.mapping.container.CollectionMapping.
postUpdate(CollectionMapping.java:279)
>     [java]      at org.jpox.store.rdbms.request.UpdateRequest.execute(
UpdateRequest.java:266)
>     [java]      at org.jpox.store.rdbms.table.ClassTable.update(ClassT
able.java:1838)
>     [java]      at org.jpox.store.StoreManager.update(StoreManager.jav
a:782)
>     [java]      at org.jpox.state.StateManagerImpl.flush(StateManagerI
mpl.java:4298)
>     [java]      at org.jpox.state.StateManagerImpl.runReachability(Sta
teManagerImpl.java:3102)
>     [java]      at org.jpox.AbstractPersistenceManager.preCommit(Abstr
actPersistenceManager.java:3049)
>     [java]      at org.jpox.NonmanagedTransaction.commit(NonmanagedTra
nsaction.java:419)
>     [java]      at org.apache.jdo.tck.models.fieldtypes.TestCollection
Collections.runTest(TestCollectionCollections.java:97)
>     [java]      at org.apache.jdo.tck.models.fieldtypes.TestCollection
Collections.test(TestCollectionCollections.java:69)
>     [java]      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
 Method)
>     [java]      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeM
ethodAccessorImpl.java:39)
>     [java]      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Del
egatingMethodAccessorImpl.java:25)
>     [java]      at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:2
04)
>     [java]      at org.apache.jdo.tck.util.BatchTestRunner.start(Batch
TestRunner.java:115)
>     [java]      at org.apache.jdo.tck.util.BatchTestRunner.main(BatchT
estRunner.java:93)
> Possibly due to a misordering of inserts required for this operation?

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secur...nistrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira

[ Post a follow-up to this message ]