Hi Erik,
> Michael,
>
> The issue is yours ;)
>
thanks!
I have the feeling it has to do with the cleanup of the
companyPMInterface configuration. I just ran the TCK twice w/o any
cleanup issues. On my run the companyPMInterface test fails since I do
not have your fix.
I will take a look at the cleanup issue as soon as I get your fix
through the maven remote repository. So you have an idea when it will be
available?
Regards Michael
> 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 <mbo.tech@spree.de>:
>
>
>> 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.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]
>>>
>>>
>> --
>> Michael Bouschen Tech@Spree Engineering GmbH
>> mailto:mbo.tech@spree.de http://www.tech.spree.de/
>> Tel.:++49/30/235 520-33 Buelowstr. 66
>> Fax.:++49/30/2175 2012 D-10783 Berlin
>>
>>
>>
>
>
>
--
Michael Bouschen Tech@Spree Engineering GmbH
mailto:mbo.tech@spree.de http://www.tech.spree.de/
Tel.:++49/30/235 520-33 Buelowstr. 66
Fax.:++49/30/2175 2012 D-10783 Berlin
|