DetachedCriteria : count before limitation?

Fearless · **Joined:** Mon Aug 16, 2010 4:47 am **Posts:** 4

Hello,

Maybe my question is stupid but I'm wondering the following thing :

If I want to limit my search results (for instance I just want the 50 first records) by using DetachedCriteria, I do :

Code:

List<Object> liste = getHibernateTemplate().findByCriteria(crit,0,50);

Everything is OK.

However, I would like to get the number total of records of the request without a COUNT before.

Clearly : just call one time findByCriteria and get the total size and my list (which is limited).

Is that possible?

Thanks in advance !

shynate26 · **Posted:** Mon Aug 16, 2010 5:07 am

Fearless,

You may set the max results to be returned as 50. But it may not always cross 50 records it may also be less than 50. If you need only the count from the query, it is advisable to use count() instead returning all the results.

As you said, you can also go with the size of the list.

britanico · **Posted:** Mon Aug 16, 2010 8:08 am

Watch out at the moment of use Projections.rowCount(), I'm having troubles trying to get the total record count with a criterion already created.

https://forum.hibernate.org/viewtopic.php?f=1&t=1006434

Fearless · **Joined:** Mon Aug 16, 2010 4:47 am **Posts:** 4

Shynate26 : you're right, but what I need is to know how many records are in my request.

Clearly : imagine I my request (with DetachedCriteria) contains 60 results and I just want the 50 first.

I do : findByCrit(crit,0,50), it's ok.

But I would like, in the same time, knowing that my request contains 60 results.

The solution is to do a COUNT but the request is heavy, I'm looking for an easier solution, maybe it doesn't exist !

Britanico : I'm gonna watch it, thanks.