Hi Erik,By the way, are you using the patched .sql scripts with the named fk constraints or the checked-in scripts?
Thanks, Craig On Apr 30, 2006, at 5:36 PM, Erik Bengtson wrote:
Hi, JPOX HEAD pass all tests and correctly clean database. Cheers Quoting "Michael Bouschen (JIRA)" <[EMAIL PROTECTED]>:test (org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstanc esMadePersistentViaReachability)javax.jdo.JDODataStoreException:[http://issues.apache.org/jira/browse/JDO-375? page=comments#action_12377192 ]Michael Bouschen commented on JDO-375: -------------------------------------- The fknames patch looks good!Company model tables are not fully cleaned up --------------------------------------------- Key: JDO-375 URL: http://issues.apache.org/jira/browse/JDO-375 Project: JDO Type: BugComponents: tck20 Versions: JDO 2 rc1 Reporter: Erik Bengtson Assignee: Erik Bengtson Fix For: JDO 2 final Attachments: JDO-375-2.patch, JDO-375-fknames.patch, JDO-375.patch Tables from company model does not appear to be clean after run.I can't say if this is a JPOX or TCK issue, because I did not dig into theissue.On second run, exceptions are like1)("NAME",FOUNDEDDATE,ADDRID,CITY,COUNTRY,"STATE",STREET,ZIPCODE,ID,DISC RIMINATOR)Insert request failed: INSERT INTO applicationidentity0.COMPANIESorg.jpox.state.StateManagerImpl.internalMakePersistent (StateManagerImpl.java:3456)org.jpox.store.rdbms.request.InsertRequest.execute (InsertRequest.java:393)VALUES (?,?,?,?,?,?,?,?,?,?) atatorg.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2171)at org.jpox.store.StoreManager.insert(StoreManager.java: 757)atorg.jpox.AbstractPersistenceManager.internalMakePersistent (AbstractPersistenceManager.java:1150)org.jpox.state.StateManagerImpl.makePersistent (StateManagerImpl.java:3429)atatorg.jpox.AbstractPersistenceManager.makePersistent (AbstractPersistenceManager.java:1205)atorg.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstance sMadePersistentViaReachability.createObjects (GetExtentWithInstancesMadePersistentViaReachability.java:72)atorg.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstance sMadePersistentViaReachability.test (GetExtentWithInstancesMadePersistentViaReachability.java:63)atsun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)atatcom.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute (NewProxyPreparedStatement.java:911)org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java: 107)at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237) atorg.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java: 147)atorg.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java: 122)atNestedThrowablesStackTrace:ERROR 23505: The statement was aborted because it would have caused aduplicatekey value in a unique or primary key constraint or unique indexidentified byorg.apache.derby.iapi.error.StandardException.newException(Unknown Source)'COMPS_PK' defined on 'COMPANIES'. atorg.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups (Unknownatorg.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source)Source) atat org.apache.derby.impl.sql.execute.IndexChanger.insert (UnknownSource)org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source)atorg.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source)atorg.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore (UnknownatSource)at org.apache.derby.impl.sql.execute.InsertResultSet.open (UnknownSource)org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)atorg.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)atorg.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement (Unknownatorg.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)Source) atatorg.jpox.store.rdbms.ParamLoggingPreparedStatement.execute (ParamLoggingPreparedStatement.java:212)atorg.jpox.state.StateManagerImpl.internalMakePersistent (StateManagerImpl.java:3456)atorg.jpox.store.rdbms.request.Request.executeUpdate(Request.java:88)org.jpox.store.rdbms.request.InsertRequest.execute (InsertRequest.java:267)atatorg.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2171)at org.jpox.store.StoreManager.insert(StoreManager.java: 757)atorg.jpox.AbstractPersistenceManager.internalMakePersistent (AbstractPersistenceManager.java:1150)org.jpox.state.StateManagerImpl.makePersistent (StateManagerImpl.java:3429)atatorg.jpox.AbstractPersistenceManager.makePersistent (AbstractPersistenceManager.java:1205)atorg.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstance sMadePersistentViaReachability.createObjects (GetExtentWithInstancesMadePersistentViaReachability.java:72)atorg.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstance sMadePersistentViaReachability.test (GetExtentWithInstancesMadePersistentViaReachability.java:63)atsun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)atattest (org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclas ses)javax.jdo.JDODataStoreException:org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java: 107)at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237) atorg.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java: 147)atorg.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java: 122)at2)(ADDRID,CITY,COUNTRY,"STATE",STREET,ZIPCODE,FIRSTNAME,BIRTHDATE,MIDDLE NAME,LASTNAME,PERSONID,DISCRIMINATOR)Insert request failed: INSERT INTO applicationidentity0.PERSONSorg.jpox.state.StateManagerImpl.internalMakePersistent (StateManagerImpl.java:3456)org.jpox.store.rdbms.request.InsertRequest.execute (InsertRequest.java:393)VALUES (?,?,?,?,?,?,?,?,?,?,?,?) atatorg.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2171)at org.jpox.store.StoreManager.insert(StoreManager.java: 757)atorg.jpox.AbstractPersistenceManager.internalMakePersistent (AbstractPersistenceManager.java:1150)org.jpox.state.StateManagerImpl.makePersistent (StateManagerImpl.java:3429)atatorg.jpox.AbstractPersistenceManager.makePersistent (AbstractPersistenceManager.java:1205)atorg.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclass es.createObjects(GetExtentWithSubclasses.java:86)atorg.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclass es.test(GetExtentWithSubclasses.java:73)atsun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)atatcom.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute (NewProxyPreparedStatement.java:911)org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java: 107)at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237) atorg.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java: 147)atorg.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java: 122)atNestedThrowablesStackTrace:ERROR 23505: The statement was aborted because it would have caused aduplicatekey value in a unique or primary key constraint or unique indexidentified byorg.apache.derby.iapi.error.StandardException.newException(Unknown Source)'EMPS_PK' defined on 'PERSONS'. atorg.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups (Unknownatorg.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source)Source) atat org.apache.derby.impl.sql.execute.IndexChanger.insert (UnknownSource)org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source)atorg.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source)atorg.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore (UnknownatSource)at org.apache.derby.impl.sql.execute.InsertResultSet.open (UnknownSource)org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)atorg.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)atorg.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement (Unknownatorg.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)Source) atatorg.jpox.store.rdbms.ParamLoggingPreparedStatement.execute (ParamLoggingPreparedStatement.java:212)atorg.jpox.state.StateManagerImpl.internalMakePersistent (StateManagerImpl.java:3456)atorg.jpox.store.rdbms.request.Request.executeUpdate(Request.java:88)org.jpox.store.rdbms.request.InsertRequest.execute (InsertRequest.java:267)atatorg.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2171)at org.jpox.store.StoreManager.insert(StoreManager.java: 757)atorg.jpox.AbstractPersistenceManager.internalMakePersistent (AbstractPersistenceManager.java:1150)org.jpox.state.StateManagerImpl.makePersistent (StateManagerImpl.java:3429)atatorg.jpox.AbstractPersistenceManager.makePersistent (AbstractPersistenceManager.java:1205)atorg.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclass es.createObjects(GetExtentWithSubclasses.java:86)atorg.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclass es.test(GetExtentWithSubclasses.java:73)atsun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)atattest (org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAnd InstancesNotReachable)javax.jdo.JDODataStoreException:org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java: 107)at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237) atorg.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java: 147)atorg.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java: 122)at3)("NAME",FOUNDEDDATE,ADDRID,CITY,COUNTRY,"STATE",STREET,ZIPCODE,ID,DISC RIMINATOR)Insert request failed: INSERT INTO applicationidentity0.COMPANIESorg.jpox.state.StateManagerImpl.internalMakePersistent (StateManagerImpl.java:3456)org.jpox.store.rdbms.request.InsertRequest.execute (InsertRequest.java:393)VALUES (?,?,?,?,?,?,?,?,?,?) atatorg.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2171)at org.jpox.store.StoreManager.insert(StoreManager.java: 757)atorg.jpox.AbstractPersistenceManager.internalMakePersistent (AbstractPersistenceManager.java:1150)org.jpox.state.StateManagerImpl.makePersistent (StateManagerImpl.java:3429)atatorg.jpox.AbstractPersistenceManager.makePersistent (AbstractPersistenceManager.java:1205)atorg.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndI nstancesNotReachable.createObjects (MakePersistentAndInstancesNotReachable.java:85)atorg.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndI nstancesNotReachable.test (MakePersistentAndInstancesNotReachable.java:69)atsun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)atatcom.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute (NewProxyPreparedStatement.java:911)org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java: 107)at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237) atorg.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java: 147)atorg.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java: 122)atNestedThrowablesStackTrace:ERROR 23505: The statement was aborted because it would have caused aduplicatekey value in a unique or primary key constraint or unique indexidentified byorg.apache.derby.iapi.error.StandardException.newException(Unknown Source)'COMPS_PK' defined on 'COMPANIES'. atorg.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups (Unknownatorg.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source)Source) atat org.apache.derby.impl.sql.execute.IndexChanger.insert (UnknownSource)org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source)atorg.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source)atorg.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore (UnknownatSource)at org.apache.derby.impl.sql.execute.InsertResultSet.open (UnknownSource)org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)atorg.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)atorg.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement (Unknownatorg.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)Source) atatorg.jpox.store.rdbms.ParamLoggingPreparedStatement.execute (ParamLoggingPreparedStatement.java:212)atorg.jpox.state.StateManagerImpl.internalMakePersistent (StateManagerImpl.java:3456)atorg.jpox.store.rdbms.request.Request.executeUpdate(Request.java:88)org.jpox.store.rdbms.request.InsertRequest.execute (InsertRequest.java:267)atatorg.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2171)at org.jpox.store.StoreManager.insert(StoreManager.java: 757)atorg.jpox.AbstractPersistenceManager.internalMakePersistent (AbstractPersistenceManager.java:1150)org.jpox.state.StateManagerImpl.makePersistent (StateManagerImpl.java:3429)atatorg.jpox.AbstractPersistenceManager.makePersistent (AbstractPersistenceManager.java:1205)atorg.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndI nstancesNotReachable.createObjects (MakePersistentAndInstancesNotReachable.java:85)atorg.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndI nstancesNotReachable.test (MakePersistentAndInstancesNotReachable.java:69)atsun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)atatorg.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java: 107)at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237) atorg.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java: 147)atorg.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java: 122)atFAILURES!!! Error summary:001 error: SQL Exception: The statement was aborted because it wouldhavecaused a duplicate key value in a unique or primary key constraint oruniqueindex identified by 'EMPS_PK' defined on 'PERSONS'.002 errors: SQL Exception: The statement was aborted because it wouldhavecaused a duplicate key value in a unique or primary key constraint oruniqueindex identified by 'COMPS_PK' defined on 'COMPANIES'. derby-app-pm-junit.txt: ** Tests run: 099, Time: 032 seconds. Failures: 0, Errors: 3Excluded tests: [org.apache.jdo.tck.enhancement.FieldAccessModified,org.apache.jdo.tck.enhancement.ImplementsPersistenceCapable]-- 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
Craig Russell Architect, Sun Java Enterprise System http://java.sun.com/products/jdo 408 276-5638 mailto:[EMAIL PROTECTED] P.S. A good JDO? O, Gasp!
smime.p7s
Description: S/MIME cryptographic signature