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
Assigned to: Michael Bouschen


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 i
ssue.

On second run, exceptions are like

> 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,DISCRIMI
NATOR)
> VALUES (?,?,?,?,?,?,?,?,?,?)
>         at org.jpox.store.rdbms.request.InsertRequest.execute(InsertReques
t.java:393)
>         at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:21
71)
>         at org.jpox.store.StoreManager.insert(StoreManager.java:757)
>         at
> org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.ja
va:3456)
>         at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl
.java:3429)
>         at
> org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersist
enceManager.java:1150)
>         at
> org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceMana
ger.java:1205)
>         at
> org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstancesMad
ePersistentViaReachability. createObjects(GetExtentWithInstancesMade
Persisten
tViaReachability.java:72)
>         at
> org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstancesMad
ePersistentViaReachability. test(GetExtentWithInstancesMadePersisten
tViaReach
ability.java:63)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm
pl.java:25)
>         at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237)
>         at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.j
ava:107)
>         at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.j
ava:147)
>         at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.ja
va:122)
> NestedThrowablesStackTrace:
> ERROR 23505: The statement was aborted because it would have caused a dupl
icate
> 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(Unkn
own Source)
>         at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDu
ps(Unknown
> Source)
>         at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown
 Source)
>         at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown S
ource)
>         at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknow
n Source)
>         at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unkn
own Source)
>         at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertC
ore(Unknown
> Source)
>         at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown 
Source)
>         at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unkn
own Source)
>         at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unkn
own Source)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatem
ent(Unknown
> Source)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unkno
wn Source)
>         at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPrepare
dStatement.java:911)
>         at
> org.jpox.store.rdbms.ParamLoggingPreparedStatement.execute(ParamLoggingPre
paredStatement.java:212)
>         at org.jpox.store.rdbms.request.Request.executeUpdate(Request.java
:88)
>         at org.jpox.store.rdbms.request.InsertRequest.execute(InsertReques
t.java:267)
>         at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:21
71)
>         at org.jpox.store.StoreManager.insert(StoreManager.java:757)
>         at
> org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.ja
va:3456)
>         at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl
.java:3429)
>         at
> org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersist
enceManager.java:1150)
>         at
> org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceMana
ger.java:1205)
>         at
> org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstancesMad
ePersistentViaReachability. createObjects(GetExtentWithInstancesMade
Persisten
tViaReachability.java:72)
>         at
> org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstancesMad
ePersistentViaReachability. test(GetExtentWithInstancesMadePersisten
tViaReach
ability.java:63)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm
pl.java:25)
>         at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237)
>         at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.j
ava:107)
>         at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.j
ava:147)
>         at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.ja
va: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,MIDD
LENAME
,LASTNAME,PERSONID,DISCRIMINATOR)
> VALUES (?,?,?,?,?,?,?,?,?,?,?,?)
>         at org.jpox.store.rdbms.request.InsertRequest.execute(InsertReques
t.java:393)
>         at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:21
71)
>         at org.jpox.store.StoreManager.insert(StoreManager.java:757)
>         at
> org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.ja
va:3456)
>         at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl
.java:3429)
>         at
> org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersist
enceManager.java:1150)
>         at
> org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceMana
ger.java:1205)
>         at
> org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclasses.c
reateObjects(GetExtentWithSubclasses.java:86)
>         at
> org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclasses.t
est(GetExtentWithSubclasses.java:73)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm
pl.java:25)
>         at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237)
>         at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.j
ava:107)
>         at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.j
ava:147)
>         at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.ja
va:122)
> NestedThrowablesStackTrace:
> ERROR 23505: The statement was aborted because it would have caused a dupl
icate
> 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(Unkn
own Source)
>         at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDu
ps(Unknown
> Source)
>         at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown
 Source)
>         at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown S
ource)
>         at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknow
n Source)
>         at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unkn
own Source)
>         at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertC
ore(Unknown
> Source)
>         at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown 
Source)
>         at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unkn
own Source)
>         at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unkn
own Source)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatem
ent(Unknown
> Source)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unkno
wn Source)
>         at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPrepare
dStatement.java:911)
>         at
> org.jpox.store.rdbms.ParamLoggingPreparedStatement.execute(ParamLoggingPre
paredStatement.java:212)
>         at org.jpox.store.rdbms.request.Request.executeUpdate(Request.java
:88)
>         at org.jpox.store.rdbms.request.InsertRequest.execute(InsertReques
t.java:267)
>         at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:21
71)
>         at org.jpox.store.StoreManager.insert(StoreManager.java:757)
>         at
> org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.ja
va:3456)
>         at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl
.java:3429)
>         at
> org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersist
enceManager.java:1150)
>         at
> org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceMana
ger.java:1205)
>         at
> org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclasses.c
reateObjects(GetExtentWithSubclasses.java:86)
>         at
> org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclasses.t
est(GetExtentWithSubclasses.java:73)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm
pl.java:25)
>         at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237)
>         at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.j
ava:107)
>         at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.j
ava:147)
>         at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.ja
va: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,DISCRIMI
NATOR)
> VALUES (?,?,?,?,?,?,?,?,?,?)
>         at org.jpox.store.rdbms.request.InsertRequest.execute(InsertReques
t.java:393)
>         at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:21
71)
>         at org.jpox.store.StoreManager.insert(StoreManager.java:757)
>         at
> org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.ja
va:3456)
>         at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl
.java:3429)
>         at
> org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersist
enceManager.java:1150)
>         at
> org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceMana
ger.java:1205)
>         at
> org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndInsta
ncesNotReachable. createObjects(MakePersistentAndInstances
NotReachable.java:8
5)
>         at
> org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndInsta
ncesNotReachable. test(MakePersistentAndInstancesNotReacha
ble.java:69)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm
pl.java:25)
>         at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237)
>         at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.j
ava:107)
>         at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.j
ava:147)
>         at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.ja
va:122)
> NestedThrowablesStackTrace:
> ERROR 23505: The statement was aborted because it would have caused a dupl
icate
> 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(Unkn
own Source)
>         at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDu
ps(Unknown
> Source)
>         at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown
 Source)
>         at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown S
ource)
>         at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknow
n Source)
>         at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unkn
own Source)
>         at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertC
ore(Unknown
> Source)
>         at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown 
Source)
>         at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unkn
own Source)
>         at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unkn
own Source)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatem
ent(Unknown
> Source)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unkno
wn Source)
>         at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPrepare
dStatement.java:911)
>         at
> org.jpox.store.rdbms.ParamLoggingPreparedStatement.execute(ParamLoggingPre
paredStatement.java:212)
>         at org.jpox.store.rdbms.request.Request.executeUpdate(Request.java
:88)
>         at org.jpox.store.rdbms.request.InsertRequest.execute(InsertReques
t.java:267)
>         at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:21
71)
>         at org.jpox.store.StoreManager.insert(StoreManager.java:757)
>         at
> org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.ja
va:3456)
>         at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl
.java:3429)
>         at
> org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersist
enceManager.java:1150)
>         at
> org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceMana
ger.java:1205)
>         at
> org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndInsta
ncesNotReachable. createObjects(MakePersistentAndInstances
NotReachable.java:8
5)
>         at
> org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndInsta
ncesNotReachable. test(MakePersistentAndInstancesNotReacha
ble.java:69)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorIm
pl.java:25)
>         at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237)
>         at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.j
ava:107)
>         at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.j
ava:147)
>         at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.ja
va: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 uniq
ue
> 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 uniq
ue
> 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/secur...nistrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira

[ Post a follow-up to this message ]