openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abe White (JIRA)" <>
Subject [jira] Commented: (OPENJPA-201) Mapping Tool ignores the @JoinColumn annotation in a @ManyToOne mapping if the table argument is used
Date Tue, 10 Apr 2007 16:43:32 GMT


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:
>             Project: OpenJPA
>          Issue Type: Bug
>         Environment: 0.9.7-incubating-SNAPSHOT
>            Reporter: George Hongell
>            Priority: Minor
>         Attachments:,
> @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

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message