@ManyToOne and @OneToMany : 2 primary keys

[Dupon David]

Hello.
as I still did not solve my problem, I will try to reformulate my question I want to make request EJB3 QL with joint.
here my tables:

    CREATE TABLE `umlssnmi` (
  `AUIS` varchar(20) NOT NULL default '',
  `CUI` varchar(20) NOT NULL default '',
  `CODE` varchar(20) NOT NULL default '',
  `TTY` varchar(5) NOT NULL default '',
  `STR` varchar(255) NOT NULL default '',
  `HIER` varchar(255) NOT NULL default '',
  `PROF` tinyint(2) NOT NULL default '0',
  `AXE` char(1) NOT NULL default 'D',
  PRIMARY KEY  (`AUIS`),
  KEY `CODE` (`CODE`),
  KEY `TTY` (`TTY`),
  KEY `CUI` (`CUI`),
  KEY `AXE` (`AXE`)
) TYPE=MyISAM;
 
 CREATE TABLE `whoart` (
  `AUIW` varchar(10) NOT NULL default '',
  `CODE` varchar(10) NOT NULL default '',
  `STR` varchar(255) NOT NULL default '',
  `FSTR` varchar(255) NOT NULL default '',
  `SOC` varchar(5) NOT NULL default '',
  `SEMTYPE` varchar(5) NOT NULL default '',
  `SRC` enum('WA','CIM') NOT NULL default 'WA',
  PRIMARY KEY  (`AUIW`),
  KEY `SOC` (`SOC`),
  KEY `CODE` (`CODE`)
) TYPE=MyISAM;

Knowing that I have the following table which has like cl�s primary both cl�s primary of the tables the preceding one.

    CREATE TABLE `wasnmi` (
  `AUIW` varchar(20) NOT NULL default '',
  `AUIS` varchar(20) NOT NULL default '',
  `MODIF` varchar(10) default NULL,
  `SRC` enum('S','MW','MS','MA') NOT NULL default 'S',
  PRIMARY KEY  (`AUIW`,`AUIS`),
  KEY `MOD` (`SRC`),
  KEY `MODIF` (`MODIF`)
) TYPE=MyISAM;
 

knowing that cardinality between these tables and ManyToMany, my question and to know if so that I can make a join

between my tables I must create tables interm�diates which contain that the primary keys like umlssnmi_wasnmi kind

and whoart_wasnmi for example, and to make @JoinTable; or the table "wasnmi" will join the tables.

I tried to implement :

For table WHOART:

    public class TermSource implements Serializable {
[�]
@OneToMany (mappedBy="auiw")
    private Collection<TermProjPK> termProjPks;
    
    public Collection<TermProjPK> getTermProjPks() {
        return termProjPks;
    }
 
    public void setTermProjPks(Collection<TermProjPK> termProjPks) {
        this.termProjPks = termProjPks;
    }
[�]
}

For UMLSSNMI table:

    
 
 
public class SnomedInter implements Serializable {
[�]
@OneToMany (mappedBy="auis")
    private Collection<TermProjPK> termProjPks;
    
    public Collection<TermProjPK> getTermProjPks() {
        return termProjPks;
    }
 
    public void setTermProjPks(Collection<TermProjPK> termProjPks) {
        this.termProjPks = termProjPks;
    }
[�]
}

The TermProjPK class which contains the primary keys of table WASNMI:

    @Embeddable
public class TermProjPK implements Serializable {
[�]
@ManyToOne
    @JoinColumn(name = "AUIW", nullable = false)
    private String auiw;
    private Collection<TermSource> termSources;
    
    public Collection<TermSource> getTermSources() {
        return termSources;
    }
 
    public void setTermSources(Collection<TermSource> termSources) {
        this.termSources = termSources;
    }
@ManyToOne
    @JoinColumn(name = "AUIS", nullable = false)
    private String auis;
    private Collection<SnomedInter> snomedInters;
     
    public Collection<SnomedInter> getSnomedInters() {
        return snomedInters;
    }
 
    public void setSnomedInters(Collection<SnomedInter> snomedInters) {
        this.snomedInters = snomedInters;
    }
[�]
}

For WASNMI table:

    public class TermProj implements Serializable {    
    
    @EmbeddedId
    protected TermProjPK termProjPK;
 
    @Column(name = "MODIF")
    private String modif;
 
    @Column(name = "SRC", nullable = false)
    private String src;
[�]
}

That does not function, because I do not know how I can reach the fields ` MODIF' and ` SRC' of the table ` WASNMI' starting from TermSource object.



Somebody already made there?. I thank you in advance

[ November 15, 2006: Message edited by: Dupon David ]

[ November 17, 2006: Message edited by: Bear Bibeault ]
[ November 17, 2006: Message edited by: Bear Bibeault ]

[Mark Spritzler]

Well you could always not map your join table, and map the two ends of your many-to-many relationship pointing to your join table.

Mark

[Dupon David]

Hi,
I thank you for this solution which appears tempting,
but my superior want imperatively that I use EJB3 with JBoss 4.0.4 and hibernate.
would have an other solution? I thank you in advance

[Mark Spritzler]

Um, my solution is using EJB3 and Hibernate. Check out the documentation on mapping Many to Many.

Mark

[Dupon David]

Hi,
In fact, the annotation @ManyToMany does not function for my case, because my table WASNMI is not simply a table of joint, but it contains of another fields that the foreign keys.

    CREATE TABLE `wasnmi` 
(  `AUIW` varchar(20) NOT NULL default '',
  `AUIS` varchar(20) NOT NULL default '', 
 `MODIF` varchar(10) default NULL,
  `SRC` enum('S','MW','MS','MA') NOT NULL default 'S', 
 PRIMARY KEY  (`AUIW`,`AUIS`), 
 KEY `MOD` (`SRC`), 
 KEY `MODIF` (`MODIF`)) TYPE 

I implemented as follows:

TermSource and SnomedInter must have a collection of TermProj, and not of TermProPK. In the same way, TermProj must only have a direct bond towards 1 TermSource and 1 SnomedInter in addition. It is HIBERNATE which is given the responsability to manage the keys themselves! Us, only the objects are managed.

TermSource :

  @OneToMany (mappedBy="auiw")
    private Collection<TermProj> termProjs;
 
     public Collection<TermProj> getTermProjs() {
        return termProjs;
    }
 
    public void setTermProjs(Collection<TermProj> termProjs) {
        this.termProjs = termProjs;
    }
  

SnomedInter :

   @OneToMany (mappedBy="auis")
    private Collection<TermProj> termProjs;
 
     private Collection<TermProj> termProjs;
    
    public Collection<TermProj> getTermProjs() {
        return termProjs;
    }
 
    public void setTermProjs(Collection<TermProj> termProjs) {
        this.termProjs = termProjs;
    }
 

TermProjPk :

   @Embeddable
public class TermProjPK implements Serializable {    
private String auiw;
@Column(name = "AUIS", nullable = false)
private String auis;
 

TermProj :

  public class TermProj implements Serializable {
    @EmbeddedId
    protected TermProjPK termProjPK;   
 
 
    @ManyToOne
    @JoinColumn("column_pk_termSource")
    private TermSource auiw;
 
    @ManyToOne
    @JoinColumn("column_pk_SnomedInter")
   private SnomedInter auis;
 
    @Column(name = "MODIF")
    private String modif;
 
    @Column(name = "SRC", nullable = false)
    private String src;
  

it remains me to be known how I can reach a SnomedInter object to leave a TermSource object!! I tested implementer as follows:

  
for (Iterator it = news.iterator(); it.hasNext()    :wink:     {
            TermSource elem = (TermSource) it.next();            
            Collection<TermProj> termProjs = elem.getTermProjs();            
            Iterator itTermProjs = termProjs.iterator();           
            while (itTermProjs.hasNext()) {              
              TermProj termproj = (TermProj) itTermProjs.next();                
              out.println(" <TR> <TD> <b>" + elem.getAuiw() + " </b> </TD> ");
              out.println(" <TD> <b>" + elem.getCode() + " </b> </TD>");
              
              out.println(" <TD> <b>" + termproj.getModif() + " </b> </TD></TR>");            
                    
            }
        }
  

an idea?

[ November 17, 2006: Message edited by: Dupon David ]

[ November 17, 2006: Message edited by: Dupon David ]
[ November 17, 2006: Message edited by: Dupon David ]

[Mike Keith]

David,

You keep looking for an answer, but you don't seem to be paying attention to the answers you are getting. You certainly didn't seem to even look past the basic chapter on OR mapping in our JPA book. Take a look in Chapter 8. There is a "Mapping Relationship State" section there that discusses your exact association table situation.

-Mike