it depends the level of your jdbc driver, because you can navigate ( next(),
last(), prev(), etc.. ) in your resultset without rexecute the query with
some sgbd, and with some other it is not possible to navigate ..
claud honnore
----- Original Message -----
From: "Shuja Nawaz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 10, 2000 4:44 AM
Subject: How to Cache the resultset???
> Hi.
>
> I want to display the records by parts. Like we have 90 records returned
by
> the query.
> 10 records are displayed at a time. When the user clicks next link then
next
> 10 records
> are displayed and so on.
> Please suggest me how to cache the records so that I don't have to
> re-execute the query
> when the user clicks for next 10 records.
> Does JDBC 2 provides any such facility?
>
> Thanks in anticipation.
>
> Regards.
>
> From:
> Shuwaz.
>
>
___________________________________________________________________________
> 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
___________________________________________________________________________
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
