Eager fetching + duplicates result

jfsublet · **Joined:** Sat Oct 01, 2005 3:53 am **Posts:** 5

Hi all,

I have faced the classical problem of duplicates result when using an eager fetching.

In one case, I thought having duplicates result but instead I had unique result.

A has a OneToMany association with B.

I insert 2 instances of A (each of them are associated with 2 B). When running the query "from A a left join fetch a.bs", I have a list which contains 2 A (no duplicates).

I add a new instance of A (with a collections of 2 B), I run again the query, and as expected, I have a list with duplicates result.

I didn't find any bug on this point.

christian · **Posted:** Fri May 04, 2007 1:25 am

jfsublet · **Joined:** Sat Oct 01, 2005 3:53 am **Posts:** 5

I didn't see anything about this problem in the FAQ.

I suppose you speak about "Hibernate does not return distinct results for a query with outer join fetching enabled for a collection".

The problem I have faced is different than this one : when I run my first query, I get no duplicate even if I set the resultTransformer to Criteria.ROOT_ENTITY.