i'm somewhat new to jsp and oracle but i need a solution that allows me to
grab only "n" number of records at a time from a "large resultset" for
display purposes.
for example, i query and get 200 records but i want to display (forward and
backward OR next and previous) 10 (or n number of records) on each page.
i've accomplished this in cold fusion to any RDMS but it's horrible b/c it
has to process the entire query each time you click Next or Prev. and then
you filter the group of records you want. i'm assuming that since the jsp
drivers are basically a subset of the JDBC API i might not have that much
for a solution (? don't know). also, i'm assuming that an Oracle cursor can
be used but might not be the best approach if "caching" is an issue.
so, any solutions or techniques for doing this cleanly would be GREATLY
appreciated. either JSP or Oracle as a solution will do fine but let me
know the downsides too.
much appreciated on any response.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
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
