tags:

views:

287

answers:

0

Hi all, I have an entity with a set say like Libray--->books Now I want to retrieve the libraries where ALL the books have a genre

So I have something like this c.createCriteria("library", "library").createCriteria("books", "book"); c.add(Restrictions.isNotNull("book.genre"));

If I execute the query I get the libraries where at least one book has a genre but I'd like hibernate to check the genre property for all the elments of the book set and return the libraries where ALL the elements satisfy the not null restriction.

Sorry for my English, I hope the problem is clear, any help is appreciated.

Thanks.