Hi There,

Im a new user to hibernate. i have a situation where i need to implement pagination on on MYSQL. when i search the web for solution i have got 3 options. 1. using a Criteria query or using ScrollableResults or using the LIMIT in the query and then do a scroll() on the result. which option is a better way to do the pagination?

here, if i use the setFirstResult and setMaxResults would that be equivalent to using LIMIT option as in MYSQL?

Your help is very much appreciated.

Thank you,
bala.

I believe the setFirstResult and setMaxResults are the dialect independent way the framework lets you do what you want to do. Otherwise you'll be tied to a given dialect.