Hibernate request. How to choose those parents who have ALL children matching the value?

Question

I am trying to write a Hibernate (JPA) query to select those parents where ALL of their children match the property.

Let me make an example ...

I want to choose those fathers who have ALL of their children blonde. If only one black-haired father is not selected.

What will the request look like? Thank you in advance!

Answer 1

Perhaps something like this will work:

From Father f where not exists (select c from f.children c where not c.hair = "BLONDE"); 

Just an idea ...

Answer 2

Try this using ALL see http://openjpa.apache.org/builds/1.1.0/docs/jpa_langref.html#jpa_langref_all_any :

 select p from parent where 'blonde'=all(parent.children.haircolor) 

Answer 3

This should also work, and it looks a little cleaner.

 SELECT p from Parent p join p.children c where c.haircolor = 'blonde';