JPOX fails new test CompletenessTestList, configuration companyListWithoutJoin

• Key: JDO-430
• Type: Bug
• Status: Resolved
• Resolution: Fixed
• Priority: Major
• Assignee: Michelle Caisse
• Reporter: Michelle Caisse
• Component/s: tck2
• Affects Version/s: JDO 2 final
• Fix Version/s: JDO 2 maintenance release 1

Description

  Overriding previous definition of reference to this.jdori.classpath
    [echo] Starting configuration="companyListWithoutJoin.conf" with database="derby" identitytype="datastoreidentity" mapping="10".
    [java] RUN CompletenessTestList.test ERROR
    [java] Description: Completeness test with companyListWithoutJoin model.
    [java] Time: 005
    [java] There was 1 error:
    [java] 1) test(org.apache.jdo.tck.mapping.CompletenessTestList)javax.jdo.JDOUserException: One or more instances could not be made persistent
    [java] at org.jpox.AbstractPersistenceManager.makePersistentAll(AbstractPersistenceManager.java:1332)
    [java] at org.apache.jdo.tck.mapping.CompletenessTestList.localSetUp(CompletenessTestList.java:78)
    [java] at org.apache.jdo.tck.JDO_Test.setUp(JDO_Test.java:236)
    [java] at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:252)
    [java] at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:107)
    [java] at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:147)
    [java] at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:122)
    [java] NestedThrowablesStackTrace:
    [java] javax.jdo.JDODataStoreException: Insert request failed: INSERT INTO datastoreidentity10.PERSONS (MIDDLENAME,WAGE,FUNDINGDEPT,HIREDATE,PERSONID,FIRSTNAME,LASTNAME,MENTOR,DEPARTMENT,WEEKLYHOURS,BIRTHDATE,MANAGER,HRADVISOR,DISCRIMIN
ATOR,HIREDATE) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
    [java] at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:406)
    [java] at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2459)
    [java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
    [java] at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3552)
    [java] at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3531)
    [java] at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1222)
    [java] at org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1267)
    [java] at org.jpox.store.rdbms.scostore.FKListStore.validateElementForWriting(FKListStore.java:1206)
    [java] at org.jpox.store.rdbms.scostore.FKListStore.internalAdd(FKListStore.java:759)
    [java] at org.jpox.store.rdbms.scostore.AbstractListStore.addAll(AbstractListStore.java:386)
    [java] at org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:225)
    [java] at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:415)
    [java] at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2459)
    [java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
    [java] at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3552)
    [java] at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3531)
    [java] at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1222)
    [java] at org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1267)
    [java] at org.jpox.store.rdbms.scostore.FKSetStore.add(FKSetStore.java:579)
    [java] at org.jpox.store.rdbms.scostore.FKSetStore.addAll(FKSetStore.java:628)
    [java] at org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:229)
    [java] at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:415)
    [java] at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2459)
    [java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
    [java] at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3552)
    [java] at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3531)
    [java] at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1222)
    [java] at org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1281)
    [java] at org.jpox.AbstractPersistenceManager.makePersistentAll(AbstractPersistenceManager.java:1322)
    [java] at org.apache.jdo.tck.mapping.CompletenessTestList.localSetUp(CompletenessTestList.java:78)
    [java] at org.apache.jdo.tck.JDO_Test.setUp(JDO_Test.java:236)
    [java] at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:252)
    [java] at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:107)
    [java] at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:147)
    [java] at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:122)
    [java] NestedThrowablesStackTrace:
    [java] ERROR 42X13: Column name 'HIREDATE' appears more than once times in the column list of an INSERT statement.
    [java] at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
    [java] at org.apache.derby.impl.sql.compile.ResultColumnList.bindResultColumnsByName(Unknown Source)
    [java] at org.apache.derby.impl.sql.compile.InsertNode.bind(Unknown Source)
    [java] at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown
 Source)
    [java] at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
    [java] at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
    [java] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
    [java] at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
    [java] at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
    [java] at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
    [java] at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
    [java] at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
    [java] at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:190)
    [java] at org.jpox.store.rdbms.RDBMSManager.getStatement(RDBMSManager.java:431)
    [java] at org.jpox.store.rdbms.RDBMSManager.getStatement(RDBMSManager.java:388)
    [java] at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:196)
    [java] at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2459)
    [java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
    [java] at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3552)
    [java] at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3531)
    [java] at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1222)
    [java] at org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1267)
    [java] at org.jpox.store.rdbms.scostore.FKListStore.validateElementForWriting(FKListStore.java:1206)
    [java] at org.jpox.store.rdbms.scostore.FKListStore.internalAdd(FKListStore.java:759)
    [java] at org.jpox.store.rdbms.scostore.AbstractListStore.addAll(AbstractListStore.java:386)
    [java] at org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:225)
    [java] at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:415)
    [java] at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2459)
    [java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
    [java] at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3552)
    [java] at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3531)
    [java] at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1222)
    [java] at org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1267)
    [java] at org.jpox.store.rdbms.scostore.FKSetStore.add(FKSetStore.java:579)
    [java] at org.jpox.store.rdbms.scostore.FKSetStore.addAll(FKSetStore.java:628)
    [java] at org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:229)
    [java] at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:415)
    [java] at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2459)
    [java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
    [java] at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3552)
    [java] at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3531)
    [java] at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1222)
    [java] at org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1281)
    [java] at org.jpox.AbstractPersistenceManager.makePersistentAll(Abstrac
tPersistenceManager.java:1322)
    [java] at org.apache.jdo.tck.mapping.CompletenessTestList.localSetUp(CompletenessTestList.java:78)
    [java] at org.apache.jdo.tck.JDO_Test.setUp(JDO_Test.java:236)
    [java] at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:252)
    [java] at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:107)
    [java] at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:147)
    [java] at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.
java:122)