What i am trying to do is very simple but...

My class Parent has a Map of children and I want to load the parent with only a subset of children. I am trying

From Parent p left join fetch p.children where p = ? and p.children.elements = ?

But i get a jdbc exception saying

"more than one row returned by a subquery used as an expression"

Do I need to create a filter or use a criteria query? Also, the elements of the child map are a CompositeUserType - is that relevant?

thanks for any help