[
http://issues.apache.org/jira/browse/JDO-430?page=comments#action_12440262 ]
Michelle Caisse commented on JDO-430:
-------------------------------------
I checked in changes to the .orm and .sql files (revision: 453382). There are
two issues:
(1) When using the mapped-by ATTRIBUTE of the employees field, as I did in the
case of datastore identity, I get
javax.jdo.JDODataStoreException: Clear request failed : UPDATE
datastoreidentity10.PERSONS SET DEPARTMENT = NULL, ORDER_COL = NULL WHERE
DEPARTMENT = ?
at org.jpox.store.rdbms.scostore.FKListStore.clear(FKListStore.java:1171)
...
ERROR 23502: Column 'ORDER_COL' cannot accept a NULL value.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
...
(2) When using the mapped-by ELEMENT of the employees field, as I did in the
case of application identity, I get
... ERROR 42X14: 'EMPLOYEES_ID_OWN' is not a column in table or VTI
'APPLICATIONIDENTITY10.PERSONS'.
I used different syntax for the two identity types simply to illustrate the two
problems in one check-in. They should be equivalent. When the problems are
resolved, we can choose one syntax to use for both cases.
Full stack traces below:
doRuntck.jdori:
[echo] Starting configuration="companyListWithoutJoin.conf" with
database="derby" identitytype="applicationidentity" mapping="10".
[java] RUN CompletenessTestList.test ERROR
[java] Description: Completeness test with companyListWithoutJoin model.
[java] Time: 004
[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:1341)
[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
applicationidentity10.PERSONS (MENTOR,WEEKLYHOURS,MANAGER,HRADVISOR,WAGE,
ME,HIREDATE,FUNDINGDEPT,PERSONID,DISCRIMINATOR,EMPLOYEES_ID_OWN,ORDER_COL)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[java] at
org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:441)
[java] at
org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2461)
[java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
[java] at
org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3578)
[java] at
org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3557)
[java] at
org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1231)
[java] at
org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1276)
[java] at
org.jpox.store.rdbms.scostore.FKListStore.validateElementForWriting(FKListStore.java:1230)
[java] at
org.jpox.store.rdbms.scostore.FKListStore.internalAdd(FKListStore.java:771)
[java] at
org.jpox.store.rdbms.scostore.AbstractListStore.addAll(AbstractListStore.java:386)
[java] at
org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:201)
[java] at
org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:450)
[java] at
org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2461)
[java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
[java] at
org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3578)
[java] at
org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3557)
[java] at
org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1231)
[java] at
org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1276)
[java] at
org.jpox.store.rdbms.scostore.FKSetStore.add(FKSetStore.java:585)
[java] at
org.jpox.store.rdbms.scostore.FKSetStore.addAll(FKSetStore.java:650)
[java] at
org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:205)
[java] at
org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:450)
[java] at
org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2461)
[java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
[java] at
org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3578)
[java] at
org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3557)
[java] at
org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1231)
[java] at
org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1290)
[java] at
org.jpox.AbstractPersistenceManager.makePersistentAll(AbstractPersistenceManager.java:1331)
[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 42X14: 'EMPLOYEES_ID_OWN' is not a column in table or VTI
'APPLICATIONIDENTITY10.PERSONS'.
[java] at
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
[java] at
org.apache.derby.impl.sql.compile.ResultColumn.bindResultColumnByName(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:206)
[java] at
org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2461)
[java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
[java] at
org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3578)
[java] at
org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3557)
[java] at
org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1231)
[java] at
org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1276)
[java] at
org.jpox.store.rdbms.scostore.FKListStore.validateElementForWriting(FKListStore.java:1230)
[java] at
org.jpox.store.rdbms.scostore.FKListStore.internalAdd(FKListStore.java:771)
[java] at
org.jpox.store.rdbms.scostore.AbstractListStore.addAll(AbstractListStore.java:386)
[java] at
org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:201)
[java] at
org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:450)
[java] at
org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2461)
[java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
[java] at
org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3578)
[java] at
org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3557)
[java] at
org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1231)
[java] at
org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1276)
[java] at
org.jpox.store.rdbms.scostore.FKSetStore.add(FKSetStore.java:585)
[java] at
org.jpox.store.rdbms.scostore.FKSetStore.addAll(FKSetStore.java:650)
[java] at
org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:205)
[java] at
org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:450)
[java] at
org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2461)
[java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
[java] at
org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3578)
[java] at
org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3557)
[java] at
org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1231)
[java] at
org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1290)
[java] at
org.jpox.AbstractPersistenceManager.makePersistentAll(AbstractPersistenceManager.java:1331)
[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] FAILURES!!!
[java] Error summary:
[java] 001 error: SQL Exception: 'EMPLOYEES_ID_OWN' is not a column in
table or VTI 'APPLICATIONIDENTITY10.PERSONS'.
[java] derby-app-companyListWithoutJoin-junit.txt:
[java] ** Tests run: 001, Time: 004 seconds. Failures: 0, Errors: 1
[java] Excluded tests: [org.apache.jdo.tck.enhancement.FieldAccessModified,
org.apache.jdo.tck.enhancement.ImplementsPersistenceCapable]
[java] [ERROR] Java Result: 1
[echo] Finished configuration="companyListWithoutJoin.conf" with
database="derby" identitytype="applicationidentity" mapping="10".
exclude:
doRuntck.jdori:
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: 004
[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:1341)
[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 (BIRTHDATE,MENTOR,FUNDINGDEPT,MIDDLENAME,PERS
EDATE,DEPARTMENT,LASTNAME,WAGE,DISCRIMINATOR,EMPLOYEES_DATASTORE_IDENTITY_OID,ORDER_COL)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[java] at
org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:441)
[java] at
org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2461)
[java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
[java] at
org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3578)
[java] at
org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3557)
[java] at
org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1231)
[java] at
org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1276)
[java] at
org.jpox.store.rdbms.scostore.FKListStore.validateElementForWriting(FKListStore.java:1230)
[java] at
org.jpox.store.rdbms.scostore.FKListStore.internalAdd(FKListStore.java:771)
[java] at
org.jpox.store.rdbms.scostore.AbstractListStore.addAll(AbstractListStore.java:386)
[java] at
org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:201)
[java] at
org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:450)
[java] at
org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2461)
[java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
[java] at
org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3578)
[java] at
org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3557)
[java] at
org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1231)
[java] at
org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1276)
[java] at
org.jpox.store.rdbms.scostore.FKSetStore.add(FKSetStore.java:585)
[java] at
org.jpox.store.rdbms.scostore.FKSetStore.addAll(FKSetStore.java:650)
[java] at
org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:205)
[java] at
org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:450)
[java] at
org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2461)
[java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
[java] at
org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3578)
[java] at
org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3557)
[java] at
org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1231)
[java] at
org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1290)
[java] at
org.jpox.AbstractPersistenceManager.makePersistentAll(AbstractPersistenceManager.java:1331)
[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 42X14: 'EMPLOYEES_DATASTORE_IDENTITY_OID' is not a column in
table or VTI 'DATASTOREIDENTITY10.PERSONS'.
[java] at
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
[java] at
org.apache.derby.impl.sql.compile.ResultColumn.bindResultColumnByName(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:206)
[java] at
org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2461)
[java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
[java] at
org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3578)
[java] at
org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3557)
[java] at
org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1231)
[java] at
org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1276)
[java] at
org.jpox.store.rdbms.scostore.FKListStore.validateElementForWriting(FKListStore.java:1230)
[java] at
org.jpox.store.rdbms.scostore.FKListStore.internalAdd(FKListStore.java:771)
[java] at
org.jpox.store.rdbms.scostore.AbstractListStore.addAll(AbstractListStore.java:386)
[java] at
org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:201)
[java] at
org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:450)
[java] at
org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2461)
[java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
[java] at
org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3578)
[java] at
org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3557)
[java] at
org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1231)
[java] at
org.jpox.AbstractPersistenceManager.makePersistentInternal(AbstractPersistenceManager.java:1276)
[java] at
org.jpox.store.rdbms.scostore.FKSetStore.add(FKSetStore.java:585)
[java] at
org.jpox.store.rdbms.scostore.FKSetStore.addAll(FKSetStore.java:650)
[java] at
org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.java:205)
[java] at
org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:450)
[java] at
org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2461)
[java] at org.jpox.store.StoreManager.insert(StoreManager.java:902)
[java] at
org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3578)
[java] at
org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3557)
[java] at
org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1231)
[java] at
org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1290)
[java] at
org.jpox.AbstractPersistenceManager.makePersistentAll(AbstractPersistenceManager.java:1331)
[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] FAILURES!!!
[java] Error summary:
[java] 001 error: SQL Exception: 'EMPLOYEES_DATASTORE_IDENTITY_OID' is not
a column in table or VTI 'DATASTOREIDENTITY10.PERSONS'.
[java] derby-dsid-companyListWithoutJoin-junit.txt:
[java] ** Tests run: 001, Time: 004 seconds. Failures: 0, Errors: 1
[java] Excluded tests: [org.apache.jdo.tck.enhancement.FieldAccessModified,
org.apache.jdo.tck.enhancement.ImplementsPersistenceCapable]
[java] [ERROR] Java Result: 1
[echo] Finished configuration="companyListWithoutJoin.conf" with
database="derby" identitytype="datastoreidentity" mapping="10".
> JPOX fails new test CompletenessTestList, configuration companyListWithoutJoin
> ------------------------------------------------------------------------------
>
> Key: JDO-430
> URL: http://issues.apache.org/jira/browse/JDO-430
> Project: JDO
> Issue Type: Bug
> Components: tck20
> Affects Versions: JDO 2 final
> Reporter: Michelle Caisse
> Assigned To: Michelle Caisse
> Fix For: JDO 2 maintenance release 1
>
>
> 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)
--
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
