Good morning

We use the pagination class Page developped by Gavin King and Eric Broyles:
on the links comments page of the web url
http://blog.hibernate.org/cgi-bin/blosx ... ation.html

This Page class uses the fact that an hibernate query can return a scrollable result set,
this is very useful to get the total number of results returned by the query
*without* to do an other query ('select count(*) from ...' ):

****
scrollableResults = query.scroll();
...
//Just retrieve from the database the elements to display in current view page
List resultsToDisplayInCurrentPage = query.setFirstResults(...).setMaxResults(...).list();
...
scrollableResults.last();
//Need to display in the current view page the total number of results returned by the query
totalResultsNumber = getScrollableResults().getRowNumber();
*****

According to the net.sf.hibernate.Criteria API, there is no method Criteria.scroll()
so the equivalent code is not possible to support pagination with Criteria query:

so is there any elegant workaround to get the total number of results with Criteria api
without doing an other query and avoiding to retrieve from the database more elements
than we need to display in the current view page?

thank you for any suggestion
F

I had the very same issue with the Criteria API

See http://forum.hibernate.org/viewtopic.php?t=934828&highlight=

The Hibernate 2.1.6 Criteria API doesn't have the scroll() method but it has been added to Hibernate 3. I hope they add this method to the next Hibernate 2.x patch.

Sanjiv

Bonjour

I add an entry for this feature request in JIRA:
http://opensource.atlassian.com/project ... se/HB-1342

please feel free to vote for me if you think like me that it would be very useful.

merci
Farid

Oops

I made a mistake in my previous message:

you should read :

please feel free to vote for this request in Jira:
http://opensource.atlassian.com/project ... se/HB-1342

sorry
F

Over in that request, a comment is made that there is an unofficial patch in JIRA that provides a count(), which a feature I'm interested in. Or should I just use Hibernate 3 (which I presume has this feature)?

H3 doesn't have count in criteria yet