Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

[b]Hibernate version:3.0 (i'm trying 3.1.1)

[b]Name and version of the database you are using:Oracle 10g

I need to implement pagination for huge amount of records from Oracle 10g db. What's the best way to do it? Are there any readymade classes available for the same? Is it good practice to use scrollable resultset?

If I use application server caching I've Out of memory problem.
I have performance problems.

Please help me,

Thanks Lety

A reply to this interests me too if any has a good answer. The pagination examples I've seen with any system tend to be awkward or highly custom or both.