db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erik Bengtson <e...@jpox.org>
Subject Re: [jira] Commented: (JDO-375) Company model tables are not fully cleaned up
Date Mon, 01 May 2006 00:36:59 GMT
Hi,

JPOX HEAD pass all tests and correctly clean database.

Cheers

Quoting "Michael Bouschen (JIRA)" <jira@apache.org>:

>     [
> 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: Bug
>
> >   Components: 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 the
> issue.
> > On second run, exceptions are like
> > > 1)
> > >
>
test(org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstancesMadePersistentViaReachability)javax.jdo.JDODataStoreException:
> > > Insert request failed: INSERT INTO applicationidentity0.COMPANIES
> > >
>
("NAME",FOUNDEDDATE,ADDRID,CITY,COUNTRY,"STATE",STREET,ZIPCODE,ID,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.GetExtentWithInstancesMadePersistentViaReachability.createObjects(GetExtentWithInstancesMadePersistentViaReachability.java:72)
> > >         at
> > >
>
org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstancesMadePersistentViaReachability.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.GetExtentWithInstancesMadePersistentViaReachability.createObjects(GetExtentWithInstancesMadePersistentViaReachability.java:72)
> > >         at
> > >
>
org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstancesMadePersistentViaReachability.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.GetExtentWithSubclasses)javax.jdo.JDODataStoreException:
> > > Insert request failed: INSERT INTO applicationidentity0.PERSONS
> > >
>
(ADDRID,CITY,COUNTRY,"STATE",STREET,ZIPCODE,FIRSTNAME,BIRTHDATE,MIDDLENAME,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.GetExtentWithSubclasses.createObjects(GetExtentWithSubclasses.java:86)
> > >         at
> > >
>
org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclasses.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.GetExtentWithSubclasses.createObjects(GetExtentWithSubclasses.java:86)
> > >         at
> > >
>
org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclasses.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.MakePersistentAndInstancesNotReachable)javax.jdo.JDODataStoreException:
> > > Insert request failed: INSERT INTO applicationidentity0.COMPANIES
> > >
>
("NAME",FOUNDEDDATE,ADDRID,CITY,COUNTRY,"STATE",STREET,ZIPCODE,ID,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.lifecycle.MakePersistentAndInstancesNotReachable.createObjects(MakePersistentAndInstancesNotReachable.java:85)
> > >         at
> > >
>
org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndInstancesNotReachable.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.MakePersistentAndInstancesNotReachable.createObjects(MakePersistentAndInstancesNotReachable.java:85)
> > >         at
> > >
>
org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndInstancesNotReachable.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]
> > >
>
> --
> 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
>
>




Mime
View raw message