HibernatePagination

This is version 1. It is not the current version, and thus it cannot be edited.
[Back to current version]   [Restore this version]

Here's an entry from the Hibernate FAQ that shows one way of doing this:

http://www.hibernate.org/118.html#A9

Are collections pageable?

Query q = s.createFilter( collection, "" ); // the trivial filter q.setMaxResults(PAGE_SIZE); q.setFirstResult(PAGE_SIZE * pageNumber); List page = q.list();

Not sure if you had a look at this : http://blog.hibernate.org/cgi-bin/blosxom.cgi/2004/08/14#pagination

The only limitation which the code snippet is that it does not had a method to return the total number of records (ie getLastPage()). Do not use

ScrollableResults scrollableResults = query.scroll(); scrollableResults.last(); rowCnt = scrollableResults.getRowNumber();

as most drivers (including Oracle) basically read all the data on the client side in order to calculate the number of rows. Hibernate 3 has added the ability of adding projections like count(*) w/ aliases to the Query.