I have a class which has two 1-many associations. My query should filter the result set on both associations. The Hibernate documentation just gives an example with a criteria on one associations:




How would I add an other criteria say to a 1-many association mates?

This does not work:



Because Hibernate thinks that I want to add the criteria mates to the kittens.

Peter.

Have a look at http://www.hibernate.org/hib_docs/reference/en/html/querycriteria.html, section 12.4. Associations. There is a little bit there about using aliases.

Your code would look something like the following: