Hello,
I have, to simplify 2 classes
Code:
@Entity
@Table(name="SEA")
public class Sea {
@Column(name="ID_OBJECT")
private long idObject;
@Column(name="TYPE")
private String type;
@Column(name="LIBELLE")
private String libelle;
and
@Entity
@Table(name="NRL")
public class Sea {
@Column(name="ID_NRL")
private long idNrl;
@Column(name="ETAT")
private String etat;
@Column(name="DT_EXP")
private Date expiration;
There is no mapping between the 2 classes. I work from a Hibernate Criteria request that already exists and that I would like to improve in order to make a left outer join. The request would be in SQL the following
Code:
select s.TYPE, s.LIBELLE, n.ETAT, n.DT_EXP from SEA s LEFT OUTER JOIN NRL n on (s.TYPE='NRL' and s.ID_OBJECT = n.ID_NRL);
How to implement this request with Hibernate Criteria ? Thank you in advance for your answers
Login
FAQ
Search
