Hi Erik, thanks! I could successfully run the TCK using the attached jars, great! Here is the result: Total tests run: 1239. All (57) configurations passed.
However, we still have the cleanup issue with the companyPMInterface test configuration. I found a bug in the test, because it was using the wrong pc classes when trying to cleanup the database. I attached a patch to issue http://issues.apache.org/jira/browse/JDO-375. However, the test still does not cleanup correctly with the patch. The cleanup code tries to get all the instances to be deleted by getting the extent of the persistent interface, run a query with the extent as candidates and delete all instances returned by the query. But the query result is empty. Do you have an idea? Regards Michael > Jars uploaded passing all tests > > Quoting Craig L Russell <[EMAIL PROTECTED]>: > >> Hi Erik, >> >> The maven repository still has no new jar files. Is it possible for >> you to upload the JPOX jars to JIRA? >> >> Thanks, >> >> Craig >> >> On Apr 27, 2006, at 6:22 AM, Erik Bengtson wrote: >> >>> Michael, >>> >>> The issue is yours ;) >>> >>> Craig, >>> >>> I recall that you asked me about the index in the descriminator for >>> the patch I >>> sent some weeks ago. The index was there due to a copy and paste, >>> and if you >>> like just drop it. >>> >>> >>> Quoting Michael Bouschen <[EMAIL PROTECTED]>: >>> >>>> Hi Erik, >>>>> Hi Craig, >>>>> >>>>> JPOX passes all tests and I will commit all changes tonight. >>>>> Although, on a >>>>> >>>> This is great news! >>>>> second run (maven runtck.jdori) I get errors like this: >>>>> >>>> This sounds like a cleanup issue in one of the tests executed >>>> prior to >>>> the ones that are failing. Could you do me a favor and file a JIRA >>>> issue? Please assign it to me, I will take a look. Thanks! >>>> >>>> Regards Michael >>>>> Rgds, >>>>> >>>>> 1) >>>>> >>> test >>> (org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstanc >>> esMadePersistentViaReachability)javax.jdo.JDODataStoreException: >>>>> Insert request failed: INSERT INTO applicationidentity0.COMPANIES >>>>> >>> ("NAME",FOUNDEDDATE,ADDRID,CITY,COUNTRY,"STATE",STREET,ZIPCODE,ID,DISC >>> RIMINATOR) >>>>> VALUES (?,?,?,?,?,?,?,?,?,?) >>>>> at >>>> org.jpox.store.rdbms.request.InsertRequest.execute >>>> (InsertRequest.java:393) >>>>> at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java: >>>>> 2171) >>>>> at org.jpox.store.StoreManager.insert(StoreManager.java:757) >>>>> at >>>>> >>> org.jpox.state.StateManagerImpl.internalMakePersistent >>> (StateManagerImpl.java:3456) >>>>> at >>>> org.jpox.state.StateManagerImpl.makePersistent >>>> (StateManagerImpl.java:3429) >>>>> at >>>>> >>> org.jpox.AbstractPersistenceManager.internalMakePersistent >>> (AbstractPersistenceManager.java:1150) >>>>> at >>>>> >>> org.jpox.AbstractPersistenceManager.makePersistent >>> (AbstractPersistenceManager.java:1205) >>>>> at >>>>> >>> org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstance >>> sMadePersistentViaReachability.createObjects >>> (GetExtentWithInstancesMadePersistentViaReachability.java:72) >>>>> at >>>>> >>> org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstance >>> sMadePersistentViaReachability.test >>> (GetExtentWithInstancesMadePersistentViaReachability.java:63) >>>>> 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:237) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.doRun >>>>> (BatchTestRunner.java:107) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.start >>>>> (BatchTestRunner.java:147) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.main >>>>> (BatchTestRunner.java:122) >>>>> NestedThrowablesStackTrace: >>>>> ERROR 23505: The statement was aborted because it would have >>>>> caused a >>>> duplicate >>>>> key value in a unique or primary key constraint or unique index >>>>> identified >>>> by >>>>> 'COMPS_PK' defined on 'COMPANIES'. >>>>> at org.apache.derby.iapi.error.StandardException.newException >>>>> (Unknown >>>> Source) >>>>> at >>>> org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups >>>> (Unknown >>>>> Source) >>>>> at org.apache.derby.impl.sql.execute.IndexChanger.doInsert >>>>> (Unknown Source) >>>>> at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown >>>>> Source) >>>>> at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown >>>> Source) >>>>> at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow >>>>> (Unknown >>>> Source) >>>>> at >>>> org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore >>>> (Unknown >>>>> Source) >>>>> at org.apache.derby.impl.sql.execute.InsertResultSet.open >>>>> (Unknown Source) >>>>> at org.apache.derby.impl.sql.GenericPreparedStatement.execute >>>>> (Unknown >>>> Source) >>>>> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement >>>>> (Unknown >>>> Source) >>>>> at >>>> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement >>>> (Unknown >>>>> Source) >>>>> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute >>>>> (Unknown >>>> Source) >>>>> at >>>>> >>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute >>> (NewProxyPreparedStatement.java:911) >>>>> at >>>>> >>> org.jpox.store.rdbms.ParamLoggingPreparedStatement.execute >>> (ParamLoggingPreparedStatement.java:212) >>>>> at org.jpox.store.rdbms.request.Request.executeUpdate >>>>> (Request.java:88) >>>>> at >>>> org.jpox.store.rdbms.request.InsertRequest.execute >>>> (InsertRequest.java:267) >>>>> at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java: >>>>> 2171) >>>>> at org.jpox.store.StoreManager.insert(StoreManager.java:757) >>>>> at >>>>> >>> org.jpox.state.StateManagerImpl.internalMakePersistent >>> (StateManagerImpl.java:3456) >>>>> at >>>> org.jpox.state.StateManagerImpl.makePersistent >>>> (StateManagerImpl.java:3429) >>>>> at >>>>> >>> org.jpox.AbstractPersistenceManager.internalMakePersistent >>> (AbstractPersistenceManager.java:1150) >>>>> at >>>>> >>> org.jpox.AbstractPersistenceManager.makePersistent >>> (AbstractPersistenceManager.java:1205) >>>>> at >>>>> >>> org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstance >>> sMadePersistentViaReachability.createObjects >>> (GetExtentWithInstancesMadePersistentViaReachability.java:72) >>>>> at >>>>> >>> org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstance >>> sMadePersistentViaReachability.test >>> (GetExtentWithInstancesMadePersistentViaReachability.java:63) >>>>> 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:237) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.doRun >>>>> (BatchTestRunner.java:107) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.start >>>>> (BatchTestRunner.java:147) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.main >>>>> (BatchTestRunner.java:122) >>>>> 2) >>>>> >>> test >>> (org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclas >>> ses)javax.jdo.JDODataStoreException: >>>>> Insert request failed: INSERT INTO applicationidentity0.PERSONS >>>>> >>> (ADDRID,CITY,COUNTRY,"STATE",STREET,ZIPCODE,FIRSTNAME,BIRTHDATE,MIDDLE >>> NAME,LASTNAME,PERSONID,DISCRIMINATOR) >>>>> VALUES (?,?,?,?,?,?,?,?,?,?,?,?) >>>>> at >>>> org.jpox.store.rdbms.request.InsertRequest.execute >>>> (InsertRequest.java:393) >>>>> at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java: >>>>> 2171) >>>>> at org.jpox.store.StoreManager.insert(StoreManager.java:757) >>>>> at >>>>> >>> org.jpox.state.StateManagerImpl.internalMakePersistent >>> (StateManagerImpl.java:3456) >>>>> at >>>> org.jpox.state.StateManagerImpl.makePersistent >>>> (StateManagerImpl.java:3429) >>>>> at >>>>> >>> org.jpox.AbstractPersistenceManager.internalMakePersistent >>> (AbstractPersistenceManager.java:1150) >>>>> at >>>>> >>> org.jpox.AbstractPersistenceManager.makePersistent >>> (AbstractPersistenceManager.java:1205) >>>>> at >>>>> >>> org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclass >>> es.createObjects(GetExtentWithSubclasses.java:86) >>>>> at >>>>> >>> org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclass >>> es.test(GetExtentWithSubclasses.java:73) >>>>> 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:237) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.doRun >>>>> (BatchTestRunner.java:107) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.start >>>>> (BatchTestRunner.java:147) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.main >>>>> (BatchTestRunner.java:122) >>>>> NestedThrowablesStackTrace: >>>>> ERROR 23505: The statement was aborted because it would have >>>>> caused a >>>> duplicate >>>>> key value in a unique or primary key constraint or unique index >>>>> identified >>>> by >>>>> 'EMPS_PK' defined on 'PERSONS'. >>>>> at org.apache.derby.iapi.error.StandardException.newException >>>>> (Unknown >>>> Source) >>>>> at >>>> org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups >>>> (Unknown >>>>> Source) >>>>> at org.apache.derby.impl.sql.execute.IndexChanger.doInsert >>>>> (Unknown Source) >>>>> at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown >>>>> Source) >>>>> at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown >>>> Source) >>>>> at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow >>>>> (Unknown >>>> Source) >>>>> at >>>> org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore >>>> (Unknown >>>>> Source) >>>>> at org.apache.derby.impl.sql.execute.InsertResultSet.open >>>>> (Unknown Source) >>>>> at org.apache.derby.impl.sql.GenericPreparedStatement.execute >>>>> (Unknown >>>> Source) >>>>> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement >>>>> (Unknown >>>> Source) >>>>> at >>>> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement >>>> (Unknown >>>>> Source) >>>>> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute >>>>> (Unknown >>>> Source) >>>>> at >>>>> >>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute >>> (NewProxyPreparedStatement.java:911) >>>>> at >>>>> >>> org.jpox.store.rdbms.ParamLoggingPreparedStatement.execute >>> (ParamLoggingPreparedStatement.java:212) >>>>> at org.jpox.store.rdbms.request.Request.executeUpdate >>>>> (Request.java:88) >>>>> at >>>> org.jpox.store.rdbms.request.InsertRequest.execute >>>> (InsertRequest.java:267) >>>>> at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java: >>>>> 2171) >>>>> at org.jpox.store.StoreManager.insert(StoreManager.java:757) >>>>> at >>>>> >>> org.jpox.state.StateManagerImpl.internalMakePersistent >>> (StateManagerImpl.java:3456) >>>>> at >>>> org.jpox.state.StateManagerImpl.makePersistent >>>> (StateManagerImpl.java:3429) >>>>> at >>>>> >>> org.jpox.AbstractPersistenceManager.internalMakePersistent >>> (AbstractPersistenceManager.java:1150) >>>>> at >>>>> >>> org.jpox.AbstractPersistenceManager.makePersistent >>> (AbstractPersistenceManager.java:1205) >>>>> at >>>>> >>> org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclass >>> es.createObjects(GetExtentWithSubclasses.java:86) >>>>> at >>>>> >>> org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclass >>> es.test(GetExtentWithSubclasses.java:73) >>>>> 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:237) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.doRun >>>>> (BatchTestRunner.java:107) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.start >>>>> (BatchTestRunner.java:147) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.main >>>>> (BatchTestRunner.java:122) >>>>> 3) >>>>> >>> test >>> (org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAnd >>> InstancesNotReachable)javax.jdo.JDODataStoreException: >>>>> Insert request failed: INSERT INTO applicationidentity0.COMPANIES >>>>> >>> ("NAME",FOUNDEDDATE,ADDRID,CITY,COUNTRY,"STATE",STREET,ZIPCODE,ID,DISC >>> RIMINATOR) >>>>> VALUES (?,?,?,?,?,?,?,?,?,?) >>>>> at >>>> org.jpox.store.rdbms.request.InsertRequest.execute >>>> (InsertRequest.java:393) >>>>> at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java: >>>>> 2171) >>>>> at org.jpox.store.StoreManager.insert(StoreManager.java:757) >>>>> at >>>>> >>> org.jpox.state.StateManagerImpl.internalMakePersistent >>> (StateManagerImpl.java:3456) >>>>> at >>>> org.jpox.state.StateManagerImpl.makePersistent >>>> (StateManagerImpl.java:3429) >>>>> at >>>>> >>> org.jpox.AbstractPersistenceManager.internalMakePersistent >>> (AbstractPersistenceManager.java:1150) >>>>> at >>>>> >>> org.jpox.AbstractPersistenceManager.makePersistent >>> (AbstractPersistenceManager.java:1205) >>>>> at >>>>> >>> org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndI >>> nstancesNotReachable.createObjects >>> (MakePersistentAndInstancesNotReachable.java:85) >>>>> at >>>>> >>> org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndI >>> nstancesNotReachable.test >>> (MakePersistentAndInstancesNotReachable.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:237) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.doRun >>>>> (BatchTestRunner.java:107) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.start >>>>> (BatchTestRunner.java:147) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.main >>>>> (BatchTestRunner.java:122) >>>>> NestedThrowablesStackTrace: >>>>> ERROR 23505: The statement was aborted because it would have >>>>> caused a >>>> duplicate >>>>> key value in a unique or primary key constraint or unique index >>>>> identified >>>> by >>>>> 'COMPS_PK' defined on 'COMPANIES'. >>>>> at org.apache.derby.iapi.error.StandardException.newException >>>>> (Unknown >>>> Source) >>>>> at >>>> org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups >>>> (Unknown >>>>> Source) >>>>> at org.apache.derby.impl.sql.execute.IndexChanger.doInsert >>>>> (Unknown Source) >>>>> at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown >>>>> Source) >>>>> at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown >>>> Source) >>>>> at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow >>>>> (Unknown >>>> Source) >>>>> at >>>> org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore >>>> (Unknown >>>>> Source) >>>>> at org.apache.derby.impl.sql.execute.InsertResultSet.open >>>>> (Unknown Source) >>>>> at org.apache.derby.impl.sql.GenericPreparedStatement.execute >>>>> (Unknown >>>> Source) >>>>> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement >>>>> (Unknown >>>> Source) >>>>> at >>>> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement >>>> (Unknown >>>>> Source) >>>>> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute >>>>> (Unknown >>>> Source) >>>>> at >>>>> >>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute >>> (NewProxyPreparedStatement.java:911) >>>>> at >>>>> >>> org.jpox.store.rdbms.ParamLoggingPreparedStatement.execute >>> (ParamLoggingPreparedStatement.java:212) >>>>> at org.jpox.store.rdbms.request.Request.executeUpdate >>>>> (Request.java:88) >>>>> at >>>> org.jpox.store.rdbms.request.InsertRequest.execute >>>> (InsertRequest.java:267) >>>>> at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java: >>>>> 2171) >>>>> at org.jpox.store.StoreManager.insert(StoreManager.java:757) >>>>> at >>>>> >>> org.jpox.state.StateManagerImpl.internalMakePersistent >>> (StateManagerImpl.java:3456) >>>>> at >>>> org.jpox.state.StateManagerImpl.makePersistent >>>> (StateManagerImpl.java:3429) >>>>> at >>>>> >>> org.jpox.AbstractPersistenceManager.internalMakePersistent >>> (AbstractPersistenceManager.java:1150) >>>>> at >>>>> >>> org.jpox.AbstractPersistenceManager.makePersistent >>> (AbstractPersistenceManager.java:1205) >>>>> at >>>>> >>> org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndI >>> nstancesNotReachable.createObjects >>> (MakePersistentAndInstancesNotReachable.java:85) >>>>> at >>>>> >>> org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndI >>> nstancesNotReachable.test >>> (MakePersistentAndInstancesNotReachable.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:237) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.doRun >>>>> (BatchTestRunner.java:107) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.start >>>>> (BatchTestRunner.java:147) >>>>> at org.apache.jdo.tck.util.BatchTestRunner.main >>>>> (BatchTestRunner.java:122) >>>>> FAILURES!!! >>>>> Error summary: >>>>> 001 error: SQL Exception: The statement was aborted because it >>>>> would have >>>>> caused a duplicate key value in a unique or primary key >>>>> constraint or >>>> unique >>>>> index identified by 'EMPS_PK' defined on 'PERSONS'. >>>>> 002 errors: SQL Exception: The statement was aborted because it >>>>> would have >>>>> caused a duplicate key value in a unique or primary key >>>>> constraint or >>>> unique >>>>> index identified by 'COMPS_PK' defined on 'COMPANIES'. >>>>> derby-app-pm-junit.txt: >>>>> ** Tests run: 099, Time: 032 seconds. Failures: 0, Errors: 3 >>>>> Excluded tests: [org.apache.jdo.tck.enhancement.FieldAccessModified, >>>>> org.apache.jdo.tck.enhancement.ImplementsPersistenceCapable] >>>>> >>>> >>>> -- >>>> Michael Bouschen [EMAIL PROTECTED] Engineering GmbH >>>> mailto:[EMAIL PROTECTED] http://www.tech.spree.de/ >>>> Tel.:++49/30/235 520-33 Buelowstr. 66 >>>> Fax.:++49/30/2175 2012 D-10783 Berlin >>>> >>>> >>> >>> >> 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! >> >> > > -- Michael Bouschen [EMAIL PROTECTED] Engineering GmbH mailto:[EMAIL PROTECTED] http://www.tech.spree.de/ Tel.:++49/30/235 520-33 Buelowstr. 66 Fax.:++49/30/2175 2012 D-10783 Berlin
