Hibernate association and child collection not pre-filtered.

hibusr11 · **Joined:** Fri Jan 02, 2009 9:44 am **Posts:** 2

Hello,

Could someone please explain why child collection in the parent is not pre-filtered by the criteria? This is described at: http://www.hibernate.org/hib_docs/refer ... tions.html
Why wouldn't a Cat instance not have only Kittens with name like "F%"?

The recommended solution is to use "setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP)". However, each Kitten object is retrieved from the map using it's alias, not from within the Cat object.
Is there a solution where Cat-Kitten object graph could have the pre-filtered objects as per the criteria?

Thank you,
hibusr11.

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

DISTINCT_ROOT_ENTITY ?

hibusr11 · **Joined:** Fri Jan 02, 2009 9:44 am **Posts:** 2

Hello,

I tried using DISTINCT_ROOT_ENTITY.

However, there are still multiple child/Kitten objects that do not match the criteria restriction. Does DISTINCT_ROOT_ENTITY only filter out duplicate root/parent/Cat objects?

List cats = sess.createCriteria(Cat.class)
.createCriteria("kittens", "kt")
.add( Restrictions.eq("name", "F%") )
.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)
.list();

Any thought on what I may be doing wrong?

Thank you for your response.
hibusr11