[
https://issues.apache.org/jira/browse/OPENJPA-201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487816
]
Abe White commented on OPENJPA-201:
-----------------------------------
I'm sorry, but I don't understand what you're trying to accomplish. You say
that Winery maps to two tables, but I don't see any SecondaryTable defined for
it. You give the results of various annotations, but I don't know what the
actual schema looks like or what relations you want mapped to what columns.
> Mapping Tool ignores the @JoinColumn annotation in a @ManyToOne mapping if
> the table argument is used
> -----------------------------------------------------------------------------------------------------
>
> Key: OPENJPA-201
> URL: https://issues.apache.org/jira/browse/OPENJPA-201
> Project: OpenJPA
> Issue Type: Bug
> Environment: 0.9.7-incubating-SNAPSHOT
> Reporter: George Hongell
> Priority: Minor
> Attachments: Wine.java, Winery.java
>
>
> @Entity
> @Table(name="CxWine")
> public class Wine {
> @Id
> private Integer wineid;
> ...
> @ManyToOne()
> @JoinColumn(name="NEW_WINERY_WINERYID", referencedColumnName="WINERYID",
> table="cxWinery")
> //ignored @JoinColumn(name="NEW_WINERY_WINERYID",
> referencedColumnName="WINERYID", table="cxWinery")
> //ignored @JoinColumn(name="NEW_WINERY_WINERYID",
> referencedColumnName="WINERYID", table="cxWinery")
> //ignored @JoinColumn(name="NEW_WINERY_WINERYID", table="cxWINERY")
> //ok @JoinColumn(name="NEW_WINERY_WINERYID", referencedColumnName="wineryid")
> //ok @JoinColumn(name="NEW_WINERY_WINERYID")
> private Winery winery;
> ...
> }
> generates
> 2744 cxwineTour TRACE [main] openjpa.jdbc.SQL - <t 1094861122, conn
> 98698722> executing stmnt 1325027066 CREATE TABLE CxWine (wineid INTEGER NOT
> NULL, cost SMALLINT, description VARCHAR(254), minimumHoldYears INTEGER,
> rating SMALLINT, stockCount INTEGER, type VARCHAR(20), version INTEGER,
> alcoholPercent DOUBLE, ava VARCHAR(40), bottler VARCHAR(40), brandName
> VARCHAR(40), labelWineClass VARCHAR(20), labelWineColor VARCHAR(20),
> estateBottled SMALLINT, hasSulfites SMALLINT, labelid INTEGER, mlContents
> INTEGER, qualityDesignation VARCHAR(40), vineyardName VARCHAR(40), vintage
> TIMESTAMP, wineName VARCHAR(40), winery_wineryid INTEGER, PRIMARY KEY
> (wineid))
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
