Hi,

I have taken the time to read all the posts here on Pagination and trying to implement pagination. However, I have not seen one example of anyone coming out and saying "Hey ! I've done it in Hibernate and here is some pseudocode". I have read about setMaxResults() and setFirstPage(), but I am still not sure of how to get a count of the total results in the resultset without issuing a .list().size(). But to get a total count of results, I would have to do a .list().size() on the Query *without* the setMax() and setFirst() and then execute the Query *with* the setMax() and setFirst() to later just limit the results to 5 or 10 or what have you per page.

So in short, is there anyone that has implement pagination in hibernate successfully *using Query* ? If so, can someone please share some ideas or some code with me to help me out ?

Thanks in advance !
S

See http://www.hibernate.org/hib_docs/reference/en/html/queryhql.html#queryhql-tipstricks.

Simply do a select count(*) something in session.iterate() or session.find()..

Hi,

Thanks for the reply. But how does this work for parameterized queries ? I have a query where I need to specify parameters, but at the same time, I need a count of how many records it will return. Your examples was simpler - just a select with no params. I have params in my query. Can someone pls point me in the right direction ?

Thanks !
S

Simply do