This will work for the "paging" aspect, but I'm more concerned with ways to cache the "resultset" itself in the session to avoid repeative database calls on each page request.
-----Original Message----- From: Rosenberg, Leon [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 6:21 AM To: Struts Users Mailing List Subject: AW: Caching data from resultset Take a look at the pager taglib. http://jsptags.com/tags/navigation/pager/pager-taglib-2.0.html regards Leon > -----Ursprüngliche Nachricht----- > Von: CRANFORD, CHRIS [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 14. Juni 2004 11:23 > An: '[EMAIL PROTECTED]' > Betreff: Caching data from resultset > > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
