Re: [jira] Assigned: (JDO-375) Company model tables are not fully cleaned up

[Craig L Russell]

I think we should remove Person.class and Employee.class from the list of teardown classes in CompletenessTest. Having them there doesn't serve any purpose since no instances of these classes are created, and they can create issues when trying to remove instances using a different strategy.

For example, look at http://issues.apache.org/jira/browse/JDO-285 for other issues related to this.

What do you think?

Craig

On Apr 30, 2006, at 8:11 AM, Michael Bouschen (JIRA) wrote:

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

Michael Bouschen reassigned JDO-375:
------------------------------------

    Assign To: Erik Bengtson  (was: Michael Bouschen)

I checked in the patch fixing getting the tearDown classes from the correct reader plus fixing list of tearDown classes in CompanyFactoryPMClass into the trunk and the 2.0 branch (see revision 398354). I think the remaining issue from preventing a correct cleanup after the test is, that the extent of a persistent interface does not include any instances. I'm assigning this issue back to Erik.

Company model tables are not fully cleaned up
---------------------------------------------

         Key: JDO-375
         URL: http://issues.apache.org/jira/browse/JDO-375
     Project: JDO
        Type: Bug

  Components: tck20
    Versions: JDO 2 rc1
    Reporter: Erik Bengtson
    Assignee: Erik Bengtson
     Fix For: JDO 2 final
 Attachments: JDO-375.patch

Tables from company model does not appear to be clean after run.

On second run, exceptions are like

I can't say if this is a JPOX or TCK issue, because I did not dig into the issue.

1)

Insert request failed: INSERT INTO applicationidentity0.COMPANIES

VALUES (?,?,?,?,?,?,?,?,?,?)

        at org.jpox.store.StoreManager.insert(StoreManager.java:757)
        at

        at

        at

        at

        at

        at

        at

        at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237)

NestedThrowablesStackTrace:

'COMPS_PK' defined on 'COMPANIES'.

Source)

Source)

Source)

        at

        at

        at org.jpox.store.StoreManager.insert(StoreManager.java:757)
        at

        at

        at

        at

        at

        at

        at

        at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237)

2)

Insert request failed: INSERT INTO applicationidentity0.PERSONS

VALUES (?,?,?,?,?,?,?,?,?,?,?,?)

        at org.jpox.store.StoreManager.insert(StoreManager.java:757)
        at

        at

        at

        at

        at

        at

        at

        at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237)

NestedThrowablesStackTrace:

'EMPS_PK' defined on 'PERSONS'.

Source)

Source)

Source)

        at

        at

        at org.jpox.store.StoreManager.insert(StoreManager.java:757)
        at

        at

        at

        at

        at

        at

        at

        at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237)

3)

Insert request failed: INSERT INTO applicationidentity0.COMPANIES

VALUES (?,?,?,?,?,?,?,?,?,?)

        at org.jpox.store.StoreManager.insert(StoreManager.java:757)
        at

        at

        at

        at

        at

        at

        at

        at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237)

NestedThrowablesStackTrace:

'COMPS_PK' defined on 'COMPANIES'.

Source)

Source)

Source)

        at

        at

        at org.jpox.store.StoreManager.insert(StoreManager.java:757)
        at

        at

        at

        at

        at

        at

        at

        at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237)

FAILURES!!!
Error summary:

index identified by 'EMPS_PK' defined on 'PERSONS'.

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]

test (org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInsta ncesMadePersistentViaReachability)javax.jdo.JDODataStoreException: ("NAME",FOUNDEDDATE,ADDRID,CITY,COUNTRY,"STATE",STREET,ZIPCODE,ID,DI SCRIMINATOR) at org.jpox.store.rdbms.request.InsertRequest.execute (InsertRequest.java:393) at org.jpox.store.rdbms.table.ClassTable.insert (ClassTable.java:2171) org.jpox.state.StateManagerImpl.internalMakePersistent (StateManagerImpl.java:3456) at org.jpox.state.StateManagerImpl.makePersistent (StateManagerImpl.java:3429) org.jpox.AbstractPersistenceManager.internalMakePersistent (AbstractPersistenceManager.java:1150) org.jpox.AbstractPersistenceManager.makePersistent (AbstractPersistenceManager.java:1205) org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstan cesMadePersistentViaReachability.createObjects (GetExtentWithInstancesMadePersistentViaReachability.java:72) org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstan cesMadePersistentViaReachability.test (GetExtentWithInstancesMadePersistentViaReachability.java:63) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) 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) 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 at org.apache.derby.iapi.error.StandardException.newException (Unknown Source) at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups (Unknown 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 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 at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source) com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute (NewProxyPreparedStatement.java:911) 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) org.jpox.state.StateManagerImpl.internalMakePersistent (StateManagerImpl.java:3456) at org.jpox.state.StateManagerImpl.makePersistent (StateManagerImpl.java:3429) org.jpox.AbstractPersistenceManager.internalMakePersistent (AbstractPersistenceManager.java:1150) org.jpox.AbstractPersistenceManager.makePersistent (AbstractPersistenceManager.java:1205) org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstan cesMadePersistentViaReachability.createObjects (GetExtentWithInstancesMadePersistentViaReachability.java:72) org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstan cesMadePersistentViaReachability.test (GetExtentWithInstancesMadePersistentViaReachability.java:63) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) 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) test (org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubcl asses)javax.jdo.JDODataStoreException: (ADDRID,CITY,COUNTRY,"STATE",STREET,ZIPCODE,FIRSTNAME,BIRTHDATE,MIDD LENAME,LASTNAME,PERSONID,DISCRIMINATOR) at org.jpox.store.rdbms.request.InsertRequest.execute (InsertRequest.java:393) at org.jpox.store.rdbms.table.ClassTable.insert (ClassTable.java:2171) org.jpox.state.StateManagerImpl.internalMakePersistent (StateManagerImpl.java:3456) at org.jpox.state.StateManagerImpl.makePersistent (StateManagerImpl.java:3429) org.jpox.AbstractPersistenceManager.internalMakePersistent (AbstractPersistenceManager.java:1150) org.jpox.AbstractPersistenceManager.makePersistent (AbstractPersistenceManager.java:1205) org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubcla sses.createObjects(GetExtentWithSubclasses.java:86) org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubcla sses.test(GetExtentWithSubclasses.java:73) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) 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) 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 at org.apache.derby.iapi.error.StandardException.newException (Unknown Source) at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups (Unknown 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 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 at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source) com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute (NewProxyPreparedStatement.java:911) 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) org.jpox.state.StateManagerImpl.internalMakePersistent (StateManagerImpl.java:3456) at org.jpox.state.StateManagerImpl.makePersistent (StateManagerImpl.java:3429) org.jpox.AbstractPersistenceManager.internalMakePersistent (AbstractPersistenceManager.java:1150) org.jpox.AbstractPersistenceManager.makePersistent (AbstractPersistenceManager.java:1205) org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubcla sses.createObjects(GetExtentWithSubclasses.java:86) org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubcla sses.test(GetExtentWithSubclasses.java:73) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) 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) test (org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentA ndInstancesNotReachable)javax.jdo.JDODataStoreException: ("NAME",FOUNDEDDATE,ADDRID,CITY,COUNTRY,"STATE",STREET,ZIPCODE,ID,DI SCRIMINATOR) at org.jpox.store.rdbms.request.InsertRequest.execute (InsertRequest.java:393) at org.jpox.store.rdbms.table.ClassTable.insert (ClassTable.java:2171) org.jpox.state.StateManagerImpl.internalMakePersistent (StateManagerImpl.java:3456) at org.jpox.state.StateManagerImpl.makePersistent (StateManagerImpl.java:3429) org.jpox.AbstractPersistenceManager.internalMakePersistent (AbstractPersistenceManager.java:1150) org.jpox.AbstractPersistenceManager.makePersistent (AbstractPersistenceManager.java:1205) org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAn dInstancesNotReachable.createObjects (MakePersistentAndInstancesNotReachable.java:85) org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAn dInstancesNotReachable.test (MakePersistentAndInstancesNotReachable.java:69) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) 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) 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 at org.apache.derby.iapi.error.StandardException.newException (Unknown Source) at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups (Unknown 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 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 at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source) com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute (NewProxyPreparedStatement.java:911) 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) org.jpox.state.StateManagerImpl.internalMakePersistent (StateManagerImpl.java:3456) at org.jpox.state.StateManagerImpl.makePersistent (StateManagerImpl.java:3429) org.jpox.AbstractPersistenceManager.internalMakePersistent (AbstractPersistenceManager.java:1150) org.jpox.AbstractPersistenceManager.makePersistent (AbstractPersistenceManager.java:1205) org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAn dInstancesNotReachable.createObjects (MakePersistentAndInstancesNotReachable.java:85) org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAn dInstancesNotReachable.test (MakePersistentAndInstancesNotReachable.java:69) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25) 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) 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 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

--
This message is automatically generated by JIRA.
-

   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

If you think it was sent incorrectly contact one of the administrators:

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