I was using rowset.jar before I started JDK 1.4. I think you could download it from the internet. Not sure if it works on your case.
Let me know if you need me to send you this package. Kathy > -----Original Message----- > From: CRANFORD, CHRIS [SMTP:[EMAIL PROTECTED] > Sent: Monday, June 14, 2004 9:55 AM > To: 'Struts Users Mailing List' > Subject: RE: Caching data from resultset > > But CachedRowSet isn't available in JDK 1.2.2_014 right? > I'm limited to this JDK because IBM AIX version our OS runs doesn't > support > a JDK after this version. > > -----Original Message----- > From: Freddy Villalba Arias [mailto:[EMAIL PROTECTED] > Sent: Monday, June 14, 2004 8:22 AM > To: Struts Users Mailing List > Subject: RE: Caching data from resultset > > > Hi Leon, > > I suppose that, since you're talking about caching the ResultSet, you've > already given a thought to the amount of data that you'd be handling, > consider it to be feasible and reasonable to cache it. > > This said, why don't you take a look at CachedRowSet? > > http://java.sun.com/j2se/1.5.0/docs/api/javax/sql/rowset/CachedRowSet.html > > http://java.sun.com/developer/Books/JDBCTutorial/chapter5.html > > I believe this could be somewhat similar to what you are looking for. > > HTH, > Freddy. > > -----Mensaje original----- > De: CRANFORD, CHRIS [mailto:[EMAIL PROTECTED] > Enviado el: lunes, 14 de junio de 2004 13:45 > Para: 'Struts Users Mailing List' > Asunto: RE: Caching data from resultset > > 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] > > > --------------------------------------------------------------------- > 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]
