Hi all, I am doing a LEFT OUTER JOIN, but I am only able to apply Restrictions on the first table. Is there a way ti apply on the second table as well?

Here is my code:



This works (applicant has an applicantName property):


Neither of these works (product has a productName property)


And this is the exception I am receiving saying (if I understand correctly) that the productName property does not exist in Applicant:



I tried to use an alias, but this generated an INNER JOIN, instead of the LEFT OUTER JOIN I want.

How can I apply restrictions on both tables?

I think the error is because your Criteria is on the Applicant and Hibernate is trying to look for the "productName" on Applicant.

Which method for Alias have you tried? some thing like below

List cats = session.createCriteria(Cat.class)
.createAlias("kittens", "kit")
.add( Restrictions.like("kit.name", "Iz%") )
.list();

OR

List cats = session.createCriteria(Cat.class)
.createCriteria("cat.kittens","kit",Criteria.LEFT_JOIN)
.add(Restrictions.like...)

-Srilatha.