Limiting results after using ResultTransformer

danlz · **Joined:** Mon May 23, 2005 10:42 am **Posts:** 1

Helo.

I'm using Hibernate 2.1.6.
I have a problem with foolowing code:

Criteria criteria = getSession().createCriteria(TemporaryReading.class);
criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

// Limit the result set
criteria.setFirstResult(firstRow);
criteria.setMaxResults(maxRows);

The problem is that Hibernate first limits the result and then eliminates duplicates.
Is there a way to do it in opposite order?

TIA

eshaggy · **Joined:** Wed Jul 20, 2005 4:17 pm **Posts:** 3

I am experiencing the same problem with Hibernate 3.0. Please provide any assistance that you can thanks.

pksiv · **Posted:** Thu Sep 08, 2005 2:53 pm

danlz wrote:

Helo.

I'm using Hibernate 2.1.6.
I have a problem with foolowing code:

Criteria criteria = getSession().createCriteria(TemporaryReading.class);
criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

// Limit the result set
criteria.setFirstResult(firstRow);
criteria.setMaxResults(maxRows);

The problem is that Hibernate first limits the result and then eliminates duplicates.
Is there a way to do it in opposite order?

TIA

I'm pretty sure there isn't since the setFirstResult()/setMaxResults() modify the query and duplicates are removed on the back-end.