I have a one-to-many association and want to be able to filter the children (by searching on them) and still be able to iterate over the parents with only the appropriate children present.

So basically I have this. Three kids aged 8, 9, and 11.



If I execute the SQL it generates, there is only one record returned, which is correct and what I want. But if I iterate through the returned Parent object, it outputs all three kids (and I know why it does, it doesn't care about my filtering).

Is there a way to prevent the parent object from loading the children that do not match the criteria?

I'm using Spring 2.5 and Hibernate Core 3.2.6.ga

There is an example of this in the documentation (http://www.hibernate.org/hib_docs/v3/re ... sociations) though I am not very familiar with the Criteria API and can't say that I fully understand what is happening. I guess though that it is only if you access the child collection through the map that it is filtered. If you access it through the parent object it will still contain all children.

The information in http://www.hibernate.org/hib_docs/v3/re ... -filtering may also be useful.