Hi Erik,

I assume that you're running the latest TCK that is checked into the svn repository?

To help figure out if there is still an issue with the TCK, could you please run the interface test multiple times by itself, e.g.

maven -Djdo.tck.cfglist=companyPMInterface.conf runtck.jdori
maven -Djdo.tck.cfglist=companyPMInterface.conf runtck.jdori

This will test that the cleanup is happening in the interface test itself. It seems to me that if the cleanup of the interfaces doesn't work correctly, it will affect other tests because the primary key for the interface instances is identical to the primary key for the class instances.

Also, to allow us to help you, can you upload the JPOX jar files as an attachment to the bug report JDO-327 so we can see what you can see?

And thanks for the info on the discriminator index. Joerg and I are still discussing whether an index is useful, so the code that Michael checked in doesn't include the index.

Regards,

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






Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to