You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-dev@db.apache.org by "Andy Jefferson (JIRA)" <ji...@apache.org> on 2007/10/09 07:32:50 UTC
[jira] Assigned: (JDO-543) CompletenessTest gives error w/ JPA
annotations in JPA*Project
[ 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.