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]
