How to force outer joins in Criteria?

sumeshjacob · **Joined:** Mon Apr 04, 2011 2:28 am **Posts:** 2

Hi,

I was trying to force outer joins in Criteria queries by setting the fetch mode as JOIN, still it is not working, but when I manually give the fetch="join" in the mapping files, this looks to be working.

Any clues how it can be made to work by setting the fetch mode?

Thanks in advance for the answers.

burroinquieto · **Joined:** Sat Sep 24, 2005 11:04 pm **Posts:** 21

Think you can use .createAlias(<propertyName>,<alias>,<join mode>) to specify the join conditions for collections or associations...

For example:

Code:

createCriteria(Person.class)
   .createAlias("vehicles", "vehicles", Criteria.LEFT_JOIN)
   .list();

would basically generate a SQL statement along the lines of:

select ... from tblPerson this_
left outer join tblVehicle vehicles1_ on this_.id = vehicles1_.personId

sumeshjacob · **Joined:** Mon Apr 04, 2011 2:28 am **Posts:** 2

Thanks for the reply and suggestion, I was able to get the outer joins, but was using

Code:

createCriteria(Person.class)
   .createAlias("vehicles", "vehicles", CriteriaSpecification.LEFT_JOIN)
   .list();

niks23 · **Joined:** Mon Apr 04, 2011 3:31 am **Posts:** 41

hi check this

http://docs.jboss.org/hibernate/core/3. ... ryhql.html