EJB 3 QL : join

[Dupon David]

Hello, I am sorry for my English level!
I based myself on the book Pro EJB 3, and exactly on chapter 4 and 6, to make a request of joint between my tables:
UMLSSNMI (SnomedInter.java is the corresponding entity Bean),
WASNMI ((TermProj.java and TermProjPK are the corresponding entity Bean), WHOART (TermSource.java is the corresponding entity Bean).

   /*
 * TermProj.java
  * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */
 
package ejb.entity;
 
import java.io.Serializable;
import javax.persistence.Column;
import javax.persistence.EmbeddedId;
import javax.persistence.Entity;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
 
/**
 *
 * @author naji2
 */
@Entity
@Table(name = "wasnmi")
@NamedQueries( {@NamedQuery(name = "TermProj.findByAuiw", query = "SELECT t FROM TermProj t WHERE t.termProjPK.auiw = :auiw"), @NamedQuery(name = "TermProj.findByAuis", query = "SELECT t FROM TermProj t WHERE t.termProjPK.auis = :auis"), @NamedQuery(name = "TermProj.findByModif", query = "SELECT t FROM TermProj t WHERE t.modif = :modif"), @NamedQuery(name = "TermProj.findBySrc", query = "SELECT t FROM TermProj t WHERE t.src = :src")})
public class TermProj implements Serializable {
 
    @EmbeddedId
    protected TermProjPK termProjPK;
 
    @Column(name = "MODIF")
    private String modif;
 
    @Column(name = "SRC", nullable = false)
    private String src;
    
    /** Creates a new instance of TermProj */
    public TermProj() {
    }
 
    public TermProj(TermProjPK termProjPK) {
        this.termProjPK = termProjPK;
    }
 
    public TermProj(TermProjPK termProjPK, String src) {
        this.termProjPK = termProjPK;
        this.src = src;
    }
 
    public TermProj(String auis, String auiw) {
        this.termProjPK = new TermProjPK(auis, auiw);
    }
 
    public TermProjPK getTermProjPK() {
        return this.termProjPK;
    }
 
    public void setTermProjPK(TermProjPK termProjPK) {
        this.termProjPK = termProjPK;
    }
 
    public String getModif() {
        return this.modif;
    }
 
    public void setModif(String modif) {
        this.modif = modif;
    }
 
    public String getSrc() {
        return this.src;
    }
 
    public void setSrc(String src) {
        this.src = src;
    }
 
    public int hashCode() {
        int hash = 0;
        hash += (this.termProjPK != null ? this.termProjPK.hashCode() : 0);
        return hash;
    }
 
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof TermProj)) {
            return false;
        }
        TermProj other = (TermProj)object;
        if (this.termProjPK != other.termProjPK && (this.termProjPK == null || !this.termProjPK.equals(other.termProjPK))) return false;
        return true;
    }
 
    public String toString() {
        return "ejb.entity.TermProj[termProjPK=" + termProjPK + "]";
    }
    
}

    /*
 * TermSource.java
 *
  * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */
 
package ejb.entity;
 
import java.io.Serializable;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
 
/**
 *
 * @author naji2
 */
@Entity
@Table(name = "whoart")
@NamedQueries( {@NamedQuery(name = "TermSource.findByAuiw", query = "SELECT t FROM TermSource t WHERE t.auiw = :auiw"), @NamedQuery(name = "TermSource.findByCode", query = "SELECT t FROM TermSource t WHERE t.code = :code"), @NamedQuery(name = "TermSource.findByStr", query = "SELECT t FROM TermSource t WHERE t.str = :str"), @NamedQuery(name = "TermSource.findByFstr", query = "SELECT t FROM TermSource t WHERE t.fstr = :fstr"), @NamedQuery(name = "TermSource.findBySoc", query = "SELECT t FROM TermSource t WHERE t.soc = :soc"), @NamedQuery(name = "TermSource.findBySemtype", query = "SELECT t FROM TermSource t WHERE t.semtype = :semtype"), @NamedQuery(name = "TermSource.findBySrc", query = "SELECT t FROM TermSource t WHERE t.src = :src")})
public class TermSource implements Serializable {
 
    @Id
    @Column(name = "AUIW", nullable = false)
    private String auiw;
 
    @Column(name = "CODE", nullable = false)
    private String code;
 
    @Column(name = "STR", nullable = false)
    private String str;
 
    @Column(name = "FSTR", nullable = false)
    private String fstr;
 
    @Column(name = "SOC", nullable = false)
    private String soc;
 
    @Column(name = "SEMTYPE", nullable = false)
    private String semtype;
 
    @Column(name = "SRC", nullable = false)
    private String src;
    
    /** Creates a new instance of TermSource */
    public TermSource() {
    }
 
    public TermSource(String auiw) {
        this.auiw = auiw;
    }
 
    public TermSource(String auiw, String code, String str, String fstr, String soc, String semtype, String src) {
        this.auiw = auiw;
        this.code = code;
        this.str = str;
        this.fstr = fstr;
        this.soc = soc;
        this.semtype = semtype;
        this.src = src;
    }
 
    public String getAuiw() {
        return this.auiw;
    }
 
    public void setAuiw(String auiw) {
        this.auiw = auiw;
    }
 
    public String getCode() {
        return this.code;
    }
 
    public void setCode(String code) {
        this.code = code;
    }
 
    public String getStr() {
        return this.str;
    }
 
    public void setStr(String str) {
        this.str = str;
    }
 
    public String getFstr() {
        return this.fstr;
    }
 
    public void setFstr(String fstr) {
        this.fstr = fstr;
    }
 
    public String getSoc() {
        return this.soc;
    }
 
    public void setSoc(String soc) {
        this.soc = soc;
    }
 
    public String getSemtype() {
        return this.semtype;
    }
 
    public void setSemtype(String semtype) {
        this.semtype = semtype;
    }
 
    public String getSrc() {
        return this.src;
    }
 
    public void setSrc(String src) {
        this.src = src;
    }
 
    public int hashCode() {
        int hash = 0;
        hash += (this.auiw != null ? this.auiw.hashCode() : 0);
        return hash;
    }
 
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof TermSource)) {
            return false;
        }
        TermSource other = (TermSource)object;
        if (this.auiw != other.auiw && (this.auiw == null || !this.auiw.equals(other.auiw))) return false;
        return true;
    }
 
    public String toString() {
        return "ejb.entity.TermSource[auiw=" + auiw + "]";
    }
    
}

    
/*
 * SnomedInter.java
  * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */
 
package ejb.entity;
 
import java.io.Serializable;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
 
/**
 *
 * @author naji2
 */
@Entity
@Table(name = "umlssnmi")
@NamedQueries( {@NamedQuery(name = "SnomedInter.findByAuis", query = "SELECT s FROM SnomedInter s WHERE s.auis = :auis"), @NamedQuery(name = "SnomedInter.findByCui", query = "SELECT s FROM SnomedInter s WHERE s.cui = :cui"), @NamedQuery(name = "SnomedInter.findByCode", query = "SELECT s FROM SnomedInter s WHERE s.code = :code"), @NamedQuery(name = "SnomedInter.findByTty", query = "SELECT s FROM SnomedInter s WHERE s.tty = :tty"), @NamedQuery(name = "SnomedInter.findByStr", query = "SELECT s FROM SnomedInter s WHERE s.str = :str"), @NamedQuery(name = "SnomedInter.findByHier", query = "SELECT s FROM SnomedInter s WHERE s.hier = :hier"), @NamedQuery(name = "SnomedInter.findByProf", query = "SELECT s FROM SnomedInter s WHERE s.prof =  :-P	 rof"), @NamedQuery(name = "SnomedInter.findByAxe", query = "SELECT s FROM SnomedInter s WHERE s.axe = :axe")})
public class SnomedInter implements Serializable {
 
    @Id
    @Column(name = "AUIS", nullable = false)
    private String auis;
 
    @Column(name = "CUI", nullable = false)
    private String cui;
 
    @Column(name = "CODE", nullable = false)
    private String code;
 
    @Column(name = "TTY", nullable = false)
    private String tty;
 
    @Column(name = "STR", nullable = false)
    private String str;
 
    @Column(name = "HIER", nullable = false)
    private String hier;
 
    @Column(name = "PROF", nullable = false)
    private short prof;
 
    @Column(name = "AXE", nullable = false)
    private char axe;
    
    //@ManyToMany
    //@JoinTable(name="TermProj", joinColumns=@JoinColumn(name="AUIS"), inverseJoinColumns=@JoinColumn(name="AUIW"))
    
    /** Creates a new instance of SnomedInter */
    public SnomedInter() {
    }
 
    public SnomedInter(String auis) {
        this.auis = auis;
    }
 
    public SnomedInter(String auis, String cui, String code, String tty, String str, String hier, short prof, char axe) {
        this.auis = auis;
        this.cui = cui;
        this.code = code;
        this.tty = tty;
        this.str = str;
        this.hier = hier;
        this.prof = prof;
        this.axe = axe;
    }
    
    
   
    public String getAuis() {
        return this.auis;
    }
 
    public void setAuis(String auis) {
        this.auis = auis;
    }
 
    public String getCui() {
        return this.cui;
    }
 
    public void setCui(String cui) {
        this.cui = cui;
    }
 
    public String getCode() {
        return this.code;
    }
 
    public void setCode(String code) {
        this.code = code;
    }
 
    public String getTty() {
        return this.tty;
    }
 
    public void setTty(String tty) {
        this.tty = tty;
    }
 
    public String getStr() {
        return this.str;
    }
 
    public void setStr(String str) {
        this.str = str;
    }
 
    public String getHier() {
        return this.hier;
    }
 
    public void setHier(String hier) {
        this.hier = hier;
    }
 
    public short getProf() {
        return this.prof;
    }
 
    public void setProf(short prof) {
        this.prof = prof;
    }
 
    public char getAxe() {
        return this.axe;
    }
 
    public void setAxe(char axe) {
        this.axe = axe;
    }
 
    public int hashCode() {
        int hash = 0;
        hash += (this.auis != null ? this.auis.hashCode() : 0);
        return hash;
    }
 
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof SnomedInter)) {
            return false;
        }
        SnomedInter other = (SnomedInter)object;
        if (this.auis != other.auis && (this.auis == null || !this.auis.equals(other.auis))) return false;
        return true;
    }
 
    public String toString() {
        return "ejb.entity.SnomedInter[auis=" + auis + "]";
    }
    
}

In my session Bean SnomedInterFacade I want to implement the method:

    public List findByCuiTmp(String cui) {
        String cui2 = cui.trim();
        return em.createQuery("select object(o) from SnomedInter as o, TermSource as a, TermProj as b WHERE o.cui='" + cui2 + "' AND a.auiw = b.auiw AND o.auis = b.auis").getResultList();
    } 

my problem it is that I do not know too much how to make the joint in this case, because my tables already exist in the base of given and the table of joint contains another elements that the primary keys thus I cannot use @JoinTable.

Can you say to me how to make in this case please