[ https://issues.apache.org/jira/browse/JDO-543?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andy Jefferson reassigned JDO-543: ---------------------------------- Assignee: Michelle Caisse (was: Andy Jefferson) Hi Michelle, you have an M-N mapping JPAAppProject @Column(name="REVIEWER") @ManyToMany(targetEntity=org.apache.jdo.tck.pc.companyAnnotatedJPA.JPAAppEmployee.class) @JoinTable(name="project_reviewer") //@JoinColumn(name="PROJID") private Set reviewers = new HashSet(); JPAAppEmployee @ManyToMany(mappedBy="reviewers", targetEntity=org.apache.jdo.tck.pc.companyAnnotatedJPA.JPAAppProject.class) private Set reviewedProjects = new HashSet(); What is the @Column doing on the "reviewers" field ? (same applies to the other M-N in that class) To name the join table columns I would have expected @JoinTable "joinColumns", "inverseJoinColumns" to be used (see http://www.jpox.org/docs/1_2/jpa_orm/many_to_many.html for details, but with XML) > CompletenessTest gives error w/ JPA annotations in JPA*Project > -------------------------------------------------------------- > > Key: JDO-543 > URL: https://issues.apache.org/jira/browse/JDO-543 > Project: JDO > Issue Type: Bug > Components: tck2 > Affects Versions: JDO 2 maintenance release 1 > Reporter: Michelle Caisse > Assignee: Michelle Caisse > > maven -Djdo.tck.cfglist=companyAnnotatedNoRelationshipsJPAConcrete.conf > runtck.jdori > gives the following error > 20:36:46,656 (main) INFO [org.apache.jdo.tck] - Exception during setUp or > runtest: > javax.jdo.JDODataStoreException: Iteration request failed : SELECT > "ELEMENT".DISCRIMINATOR,"ELEMENT".BIRTHDATE,"ELEMENT".FIRSTNAME,"ELEMENT".LASTNAME,"ELEMENT".PERSONID,"ELEMENT".HIREDATE,"ELEMENT".WEEKLYHOURS > FROM applicationidentity0.REVIEWER THIS INNER JOIN > applicationidentity0.PERSONS "ELEMENT" ON "ELEMENT".PERSONID = > THIS.PERSONID_EID WHERE ("ELEMENT".DISCRIMINATOR = ? OR > "ELEMENT".DISCRIMINATOR = ? OR "ELEMENT".DISCRIMINATOR = ?) AND ? = > THIS.PROJID_OID > at > org.jpox.jdo.JPOXJDOHelper.getJDOExceptionForJPOXException(JPOXJDOHelper.java:288) > at org.jpox.jdo.JDOTransaction.commit(JDOTransaction.java:104) > at > org.apache.jdo.tck.mapping.CompletenessTest.localSetUp(CompletenessTest.java:85) > at org.apache.jdo.tck.JDO_Test.setUp(JDO_Test.java:237) > at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:253) > at junit.framework.TestResult$1.protect(TestResult.java:106) > at junit.framework.TestResult.runProtected(TestResult.java:124) > at junit.framework.TestResult.run(TestResult.java:109) > at junit.framework.TestCase.run(TestCase.java:118) > at junit.framework.TestSuite.runTest(TestSuite.java:208) > at junit.framework.TestSuite.run(TestSuite.java:203) > at junit.textui.TestRunner.doRun(TestRunner.java:116) > at > org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) > at > org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) > at > org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) > NestedThrowablesStackTrace: > ERROR 42X05: Table/View 'APPLICATIONIDENTITY0.REVIEWER' does not exist. > at org.apache.derby.iapi.error.StandardException.newException(Unknown > Source) > at > org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown > Source) > at > org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown > Source) > at > org.apache.derby.impl.sql.compile.TableOperatorNode.bindNonVTITables(Unknown > Source) > at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source) > at > org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source) > at > org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source) > at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown > Source) > at org.apache.derby.impl.sql.compile.CursorNode.bind(Unknown Source) > at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) > at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) > at > org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown > Source) > Same with datastore identity -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.