Pagination: Number of results

gonzalezcarlos@netfocus.e · **Joined:** Wed Oct 06, 2004 4:15 am **Posts:** 16

Hibernate version: 2.1.6

Hi All,

I was reviewing the post from Gavin King about pagination, in http://blog.hibernate.org/cgi-bin/blosx ... ation.html.

The implementation is really nice, but I wonder if it's possible not only to know if there are pages before and after the requested page, but also to know the number of total pages (or total results of the query being paginated).

Of course that I can make another query with (select count(*)...), but the question is, can I make this with only one query?? (i.e. using the query object enclosed in the page implementation from Gavin?

christian · **Posted:** Wed Oct 06, 2004 4:26 am

This is not possible in one query, even without Hibernate.

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

It is possible with Scrollable Resultset - You go to last row and get row number

It is only one query

regards

adcworks · **Joined:** Fri Jun 18, 2004 10:17 am **Posts:** 140

in sql server you can assign multiple result sets to a stored procedure also, so your last select would be the count, and so (without hibernate) in jdbc you would make several calls to getResultSet().