Regarding retrievel of data

From: Ravi Shankar (sujashankar_at_pacific.net.sg)
Date: 03/13/04 

Date: Sat, 13 Mar 2004 11:38:13 +0800

Hi all,
We have some complex J2EE applications currently. IN most of the
applications, we need to take thousands of rows data from the database.Then
in the JSPs, we need to paginate them, means 100 rows per page and then next
etc. Each time the connection is established with the database and retrieve
data. One of the strategy to avoid making these mutiple connections is to
fecth all data and keep in a cache( say a stateful session bean).

As an another strategy someone proposed use of curser. Is this advantageous
over the previous strategy?

In corporate environments, how such a problem is resolved? Any design
patterns for this? Please help, thanks in advance.

Ravi