Many people mentioned
JDBC scrollable resultset in the above
thread.
It is a great solution since the
huge data set is stored at the
database end. But it does require
you to maintain an active connection
to the database at all time.
I guess this is a small price
to pay if you really want large
multipage results.