I am working with Oracle 8i and JDBC and was curious how others have implemented paging through large record resultsets from a JSP application without making a SQL call from page to page to retreive the data and looping through records to place the cursor at the right offset in the resultset.
What I would prefer to do is make the database call once and cache the resultset object and as the user navigates forward, fetch row-by-row of only those required for the display. Then if the user navigates backward, those records are in a cache inside this bean so the cache is referenced for the data (due to the fact Oracle's resultset is forward step only). Is anyone familiar or done anything like this in the past? _______________________________________________________ Chris Cranford Programmer/Developer SETECH Inc. & Companies 6302 Fairview Rd, Suite 201 Charlotte, NC 28210 Phone: (704) 362-9423, Fax: (704) 362-9409, Mobile: (704) 650-1042 Email: [EMAIL PROTECTED]
