inner join fetch in criteria api

yfmoan · **Joined:** Mon Sep 27, 2004 11:51 pm **Posts:** 22

Hi ,

There is is inner join fetch in Hibernate Reference Doc 3.1.3 , pg143.

Code:

from Cat as cat inner join fetch cat.mate left join fetch cat.kittens

How to do it using Criteria api ?

moon

calin · **Joined:** Wed Nov 23, 2005 5:01 am **Posts:** 15

Hi,

You can do that with the following:

Quote:

List result=(List) session.createCriteria( Cat.class )
.setFetchMode("mate", FetchMode.EAGER)
.setFetchMode("kittens", FetchMode.EAGER).list()

I hope this help

Calin

yfmoan · **Joined:** Mon Sep 27, 2004 11:51 pm **Posts:** 22

this will get two outer joins , right ?
what l want is "inner join fetch" , not "left join fetch" , or l miss something ? :)

moon

calin · **Joined:** Wed Nov 23, 2005 5:01 am **Posts:** 15

Hi,
Sorry, was my mistake. Yes you have right it will perform to outer join.

I don't think that you can obtain the same result with Criteria API. It is known that there are differences between the HQL and Criteria API. The HQL is more flexible.

yfmoan · **Joined:** Mon Sep 27, 2004 11:51 pm **Posts:** 22

:) .... l use criteria api mostly because of *dynamic query* , if l cannot do it in criteria api , then l have to code a lot .....

moon

martindobias · **Joined:** Tue Feb 21, 2006 10:34 am **Posts:** 7

from Hibernate 3.1.3 you can do following

Code:

List result = session.createCriteria(Cat.class) 
.createAlias("mate", "m", CriteriaSpecification.INNER_JOIN) 
.createAlias("kittens", "k", CriteriaSpecification.LEFT_JOIN).list()

Is it what you are looking for?
(note that online docs available on hibernate web page shows old javadoc and this function is not described there, download latest release - proper javadoc is included)

ge0ffrey · **Joined:** Thu Oct 13, 2005 4:19 am **Posts:** 98

The above doesn't do an eager fetch as far as I know.

We seem to come to the conclusion that "left join fetch" works in criteria, but "inner join fetch" doesn't, at least in hibernate 3.2.5.ga. It just ignores the setFetchMode part when doing an inner join.