Hi,

After googling around, I've found surprisingly little info on how paging works within Hibernate. I mean.. how to use it is very cut and dry, but I would like to know more about what it's doing.

There are two possibilities that I see..

1) Hibernate makes a normal query but only loads those objects in the specified page
2) Hibernate modifies the query to only return records for the specified page

I guess I could take a look at the actual queries sent.. but if option 2 is used then I quess this would be very database specific, and might not even apply for all databases.

Any insights available?

Thanks.

The database dialect is used to determine to appropriate query. Look at the code, the Oracle9Dialect is a good example.

This stuff is even better in v21branch in current CVS. Big improvement.

Thanks for the feedback guys.. that was just what I was looking for.

Can I ask what's drastically improved in the v21 branch?? or do I just have to look at it myself? ;)