openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maria Jurcovicova (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OPENJPA-2126) Default join table column name in many-to-many relationship does not follow JPA v2 specification
Date Thu, 23 Feb 2012 13:43:46 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-2126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13214640#comment-13214640
] 

Maria Jurcovicova commented on OPENJPA-2126:
--------------------------------------------

I would expect that naming generation rules when the @ManyToMany is being represented by a
Map should be the same as when it is represented by a Collection. 

I changed this issue priority to Minor, since it does not really need it to be fixed.
                
> 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

        

Mime
View raw message