Hi,

i have a problem with define criteria for collection (LIST).

my objectA:



object Load:



i need define criteria:



but, problem is I have too many rows in result:

the first object A with 3 load objects.
the second object A with 2 load objects.
the third object A with 1 load object.

the result:

first objectA - load1
first objectA - load2
first objectA - load3
first objectA - load1
first objectA - load2
first objectA - load3
first objectA - load1
first objectA - load2
first objectA - load3
second objectA - load1
second objectA - load2
second objectA - load1
second objectA - load2
third objektA - load1
third objektA - load2

why I have not this result:

first objectA - load1
first objectA - load2
first objectA - load3
second objectA - load1
second objectA - load2
third objektA - load1
third objektA - load2

thanks!

Ivan

Hi,

I think you can try using Distinct clause. In criteria API you filter the retrieved list using

import org.hibernate.transform.DistinctRootEntityResultTransformer;

return new DistinctRootEntityResultTransformer().transformList(list);

where list is the results u have got after executing Criteria. Important thing is doing distinct this way is totally different from having Distinct in select clause as SQL or HQL level, as here first you get the whole result set from DB and then you filter out the duplicates.

Another way of doing the same is

dateValidCriteria..setResultTransformer(new DistinctRootEntityResultTransformer());

before you do dateValidCriteria.list();

Regards
Deepak

thank you for your answer.

my criteria:

Criteria dateValidCriteria = session.createCriteria(ObjectA.class).
setFetchMode("loads", FetchMode.JOIN).
setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

but, result is still WRONG.

Ivan

this is OK:

Criteria dateValidCriteria = session.createCriteria(ObjectA.class).
setFetchMode("loads", FetchMode.SELECT).
setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

BUT, when i add condition for loads:

Criteria dateValidCriteria = session.createCriteria(ObjectA.class).
setFetchMode("loads", FetchMode.SELECT).
createCriteria("loads").
add(disjunction).
setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

this fails.

Ivan