HQL: Left Join On with using reference to two entities

Description

There some entities and HQL query:

@Entity
public class Visit implements Serializable{
@Id
private Integer id;

@JoinColumn(name = "ID_SLUCH_MED", referencedColumnName = "ID", nullable = false)
@ManyToOne(optional = false, fetch = FetchType.LAZY)
private Sluch idSluchMed;

@Temporal(TemporalType.TIMESTAMP)
private Date visitDate;
}

@Entity
public class Sluch implements Serializable {

@Id
private Integer id;

@JoinColumn(name = "ID_INSURED", referencedColumnName = "ID", nullable = false)
@ManyToOne(optional = false, fetch = FetchType.LAZY)
private Insured idInsured;

@OneToMany(cascade = CascadeType.ALL, mappedBy = "idSluchMed", fetch = FetchType.LAZY)
private List<Visit> visitList;
}

@Entity
public class Insured implements Serializable {

@Id
private Integer id;

@OneToMany(cascade = CascadeType.ALL, mappedBy = "idInsured", fetch = FetchType.LAZY)
private List<Sluch> sluchList;

@OneToMany(cascade = CascadeType.ALL, mappedBy = "idInsured", fetch = FetchType.LAZY)
private List<HistInvalid> histInvalidList;
}

@Entity
public class HistInvalid implements Serializable {
@Id
private Integer id;

@Column(name = "BEGDATE")
@Temporal(TemporalType.TIMESTAMP)
private Date begdate;

@Column(name = "ENDDATE")
@Temporal(TemporalType.TIMESTAMP)
private Date enddate;

@JoinColumn(name = "ID_INSURED", referencedColumnName = "ID", nullable = false)
@ManyToOne(optional = false, fetch = FetchType.LAZY)
private Insured idInsured;
}

SELECT v
FROM Visit v
LEFT JOIN v.idSluchMed s
LEFT JOIN s.idInsured i
LEFT JOIN i.histInvalidList h
ON h.begdate < v.visitDate

And I have the following exception:
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: with-clause referenced two different from-clause elements

Please, tell me about how I can write this query.

Activity

Show:

Brett Meyer January 16, 2014 at 5:48 AM

Please start these types of questions at the user forum: https://forum.hibernate.org/viewforum.php?f=1. JIRA tickets are only for concise, reproducible issues, rather than general questions.

Rejected

Details

Assignee

Reporter

Labels

Components

Affects versions

Priority

Created January 16, 2014 at 5:20 AM
Updated January 16, 2014 at 5:48 AM
Resolved January 16, 2014 at 5:48 AM