Hi!

I have three entities:

User { School school; }
School { City city; }
City { Integer id; }

I want to get count of users with the city id of 1.

My criteria:
Criteria crit = session.createCriteria(User.class, "u");
crit.createAlias("school.city", "cty", Criteria.INNER_JOIN);
crit.add(Restrictions.eq("cty.id", cityId));
crit.setProjection(Projections.count("id"));

Problem:
Hibernate: select count(this_.id) as y0_ from users this_ where this_.type=? and cty1_.id=? and this_.active=?
Unknown column 'cty1_.id' in 'where clause'

The expected query would be:
select count(u.id) from users u, schools s where u.active=1 and u.school_id = s.id and s.city_id = 1

Please help, because I tried I guess almost everything :) Of course, the same query without the projection works fine.
Thank you very much.

Hi All,

Someone knows how to resolve this?

I'm having the same problem, hibernate ignore my join and I don't know how to do this.

Thanks

You need another alias:


you can also use the chaining syntax to make your code more readable:

Tks a lot man.

Works so good for me!