On Thu, 12 Apr 2001, Debasis Dash wrote:
> I am requesting aquery which return 5000 results. But i want to show only 25
> record per page. But i dont want to retrive all record at the same time
> sothat it will take a lot of time for the first time. also not want to
> connect to dastabase for each request for next 25 records. How to build the
> caching mechanism for this.
>
You could store the Connection, Statement, and ResultSet into the
HttpSession, after you have read 25 rows.
Also there is "ResultSet.absolute(int rows)" in JDBC 2.0, if you have a
good JDBC driver.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets