You can use SQL cursors if the DB supports them, and if the jdbc
drivers support them. This requires that you hold the DB connection open
for long periods of time though, and is usually avoided. Another way is
to fetch and cache the results on the servlet server. Both have their
down sides.
On Wed, 5 Apr 2000, Umashankar Balasubramanian wrote:
> I get a huge number of records (in thousands) when I
> issue query from a servelet. Presently I pump all this
> info. to the browser and it is very slow.
>
> I want to implement prev/next buttons on the browser
> so that only a set of records is fetched from the
> servlet.
>
> What changes need to be done on the servlet (I have
> the constraint of not issuing the query more than
> once)
>
> Regards,
> Uma
>
> __________________________________________________
> Do You Yahoo!?
> Talk to your friends online with Yahoo! Messenger.
> http://im.yahoo.com
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
