Outer join with Criteria

billpwc · **Joined:** Tue Aug 30, 2005 1:53 pm **Posts:** 1

Is it possible to use outer join in Criteria??

session.createCriteria(City.class)
.createCriteria("country", "country")
.setFetchMode("country", FetchMode.JOIN)
.addOrder(Order.asc("country.code"))
.list();

The sql generated always use inner join between City and country. Here is the mapping file in City:

<many-to-one name="country" class="Country" column="country_id"
fetch="join" not-null="false" />

Am I missing something??

andersonbd27 · **Joined:** Wed Sep 14, 2005 9:11 am **Posts:** 22

you ever get any resolution on this? I'm running into the same thing right now.

kochcp · **Posted:** Thu Oct 20, 2005 11:50 am

try

Code:

outer-join="true"

and see if that has any effect.

and if it isn't supported in criteria, try just using hql

kochcp · **Posted:** Thu Oct 20, 2005 11:56 am

from the online documentation
http://www.hibernate.org/hib_docs/v3/re ... teria.html
Section 16.5

Quote:

You may specify association fetching semantics at runtime using setFetchMode().

List cats = sess.createCriteria(Cat.class)
.add( Restrictions.like("name", "Fritz%") )
.setFetchMode("mate", FetchMode.EAGER)
.setFetchMode("kittens", FetchMode.EAGER)
.list();

This query will fetch both mate and kittens by outer join. See Section 20.1, “Fetching strategies” for more information.

andersonbd27 · **Joined:** Wed Sep 14, 2005 9:11 am **Posts:** 22

Thanks for the response... to your first solution - I'm trying to keep specific fetching strategies out of my hbm file because I'm doing that in my individual DAO's. Which addresses your second solution as well. I'm already doing that with no such luck. Any other ideas?
Thanks
Ben