ResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)

[Alireza Hanifi]

i have a query with join fetch one to many relations.

query.from(cat)
    .innerJoin(cat.mate, mate).fetch()
    .leftJoin(cat.kittens, kitten).fetch()
    .list(cat);

when i seeing result, the cat entity duplicated to kittens size count. but i want to see one cat with a fetched related kittens property.

when we using Distinct() the problem has solving, but it occurs another problem.

in the cat entity we have BLOB column and we can't use distinct in Oracle db on Blob columns. 

i think answer is using of "setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)" but i couldn't find it in QueryDSL.

[timowest]

Hi Alireza.

Query provides the GroupBy API for result post processing, but in this case a simple List -> Set -> List transformation might be the best

http://stackoverflow.com/questions/12242083/remove-duplicates-from-list-using-guava

Timo