what's wrong with my Criteria..?

a2ps · **Joined:** Mon Oct 01, 2007 6:23 am **Posts:** 20

Hii,

Im wondering if this is the right maner to select by criteria..

my classes:

Code:

public class Person{

private User user;
}
public class User {

private Company company; 
...

}

public class Company{

private log companyId;
private String name;
...
}

the criteria is simple:

Code:

DetachedCriteria crit = DetachedCriteria.forClass(Person.class)
.createAlias("user", "u")
.add(Restrictions.eq("u.company.name", "myCompany"))
.setFetchMode("user.company", FetchMode.JOIN);

I get a strange exception..

Code:

org.springframework.orm.hibernate3.HibernateQueryException: could not resolve property: company.name

NB: if I change company.name by company.companyId works!!!

thanks for help!!

sethrohit1977 · **Joined:** Mon Jan 22, 2007 10:32 am **Posts:** 101

I think you need to create alias for company too. Try something like

DetachedCriteria crit = DetachedCriteria.forClass(Person.class)
.createAlias("user", "u")
.createAlias("company","c")
.add(Restrictions.eq("c.name", "myCompany"));

a2ps · **Joined:** Mon Oct 01, 2007 6:23 am **Posts:** 20

thanks sethrohit1977..
with alias it works, i dont understand why i dont need alias for other objects..

best regards !

sethrohit1977 · **Joined:** Mon Jan 22, 2007 10:32 am **Posts:** 101

Criteria api doesn't traverse through associations by itself. createAlias actually creates a aliased join for an association. While using criteria queries you need to create aliases for a association to create a join condition and then only you would be able to put restriction on properties of joined objects.

HTH