CODEWITHSUNDEEP
hibernatecriteriaouter-join
Markos Fragkakis
Markos Fragkakis

Reputation: 7771

(Lazy) LEFT OUTER JOIN using the Hibernate Criteria API

I want to perform a LEFT OUTER JOIN between two tables using the Criteria API. All I could find in the Hibernate documentation is this method:

Criteria criteria = this.crudService
            .initializeCriteria(Applicant.class)
            .setFetchMode("products", FetchMode.JOIN)
            .createAlias("products", "product");

However, this either performs an inner join or a right outer join, because of the number of results it returns.

I also want my join to be Lazy. How can I do this?

Cheers!

UPDATE: It seems that using aliases makes the join INNER JOIN automatically. There is something in the "background story" I have not grasped yet. So, no alias today. This leaves me with the problem of applying restrictions to the two tables, because they both have a column (or property, if this is more appropriate) 'name'.

Upvotes: 23

Views: 43182

Answers (3)

Ankit Sharma
Ankit Sharma

Reputation: 1565

Sdavids answer's API is deprecated now. Its updated version is

....createAlias("employee", "emp", JoinType.LEFT_OUTER_JOIN)

Upvotes: 27

sdavids
sdavids

Reputation: 1537

If you need to left join on the products table just do:

.....createAlias("products", "product", Criteria.LEFT_JOIN);

Upvotes: 39

KLE
KLE

Reputation: 24159

A join is in the SQL request. It can't be lazy.

With Hibernate, to retrieve lazily this data, just exclude it from the HQL request. Then, when you access the getters on your entity (if your Session is still open), it will be loaded automatically (you don't have to write that part of the request).

Upvotes: 0

Related Questions