openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Maria Jurcovicova (Created) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (OPENJPA-2126) Default join table column name in many-to-many relationship does not follow JPA v2 specification
Date Fri, 10 Feb 2012 13:56:59 GMT
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


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