Pro EJB 3 book of Mr Mike keith and Merrick Schincariol !!

[Dupon David]

Hello.
In the Pro EJB 3 book, and more precisely in the chapter 4 "OBJECT-RELATIONAL MAPPING", one do not treat the case of a table of association which contains elements other than the primary keys. Here a problem that I met and who I will be content if somebody can propose a solution to me.

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 16, 2006: Message edited by: Dupon David ]
[ November 16, 2006: Message edited by: Dupon David ]

[Mark Spritzler]

Please refrain from duplicate posting the same question multiple times. I have responded to your other thread with this same question. Closing this thread.

Thanks

Mark