You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Maria Jurcovicova (Updated) (JIRA)" <ji...@apache.org> on 2012/02/23 14:41:46 UTC
[jira] [Updated] (OPENJPA-2126) Default join table column name in
many-to-many relationship does not follow JPA v2 specification
[ https://issues.apache.org/jira/browse/OPENJPA-2126?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Maria Jurcovicova updated OPENJPA-2126:
---------------------------------------
Priority: Minor (was: Major)
> Default join table column name in many-to-many relationship does not follow JPA v2 specification
> ------------------------------------------------------------------------------------------------
>
> Key: OPENJPA-2126
> URL: https://issues.apache.org/jira/browse/OPENJPA-2126
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc, jpa
> Affects Versions: 2.1.1
> Reporter: Maria Jurcovicova
> Priority: Minor
>
> According to JPA v2 specification page 48, the joining table should have two columns. One column should have foreign key to owners table and the other should have foreign key to the inverse table.
> The name of the column referencing the owner should be:
> * the name of the relationship property or field of inverse entity ;
> * underscore "_";
> * the name of the primary key column in owner table.
> OpenJPA assumes that the name of the column referencing the owner is:
> * owner entity name ;
> * underscore "_";
> * the name of the primary key column in owner table.
> The name of the column referencing the inverse is correct.
> Example entities:
> @Entity
> @Table(name="tblMtmOwner")
> public class MtmOwner {
> @Id
> private long id;
> private String name;
> @ManyToMany
> private Collection<MtmInverse> inverses = new ArrayList<MtmInverse>();
> }
>
> @Entity
> public class MtmInverse{
> @Id
> private long id;
> @ManyToMany(mappedBy="inverses")
> @MapKey(name="name")
> private Map<String, MtmOwner> owners = new HashMap<String, MtmOwner>();
> }
> Expected column name: owners_id
> OpenJPA column name: mtmowner_id
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira