How to fetch subobjects without getting duplicate rows?

John Vance · **Joined:** Sat Oct 18, 2008 8:26 pm **Posts:** 1

This should be a simple thing.

I have surveys. Each survey can have 0 to N attachments. I want to fetch all of my surveys, and all of their attachments. My object structure is that a Survey has a List of attachments.

I'm using Hibernate annotations. If I use fetchtype.EAGER, I get a duplicate row for every attachment a survey has. If I use fetchtype.LAZY, I get a runtime error because the session is closed when I go to access my attachments.

To summarize, if I have 5 surveys each with 3 attachments, I want 5 elements in my returned List, not 15. Is there a way to do this without having to filter the results through a LinkedHashSet first?

Thanks in advance.

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

Apply a transformation to your Hibernate query, using

Code:

mycriteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);