RE: Caching data from resultset - reply

[Kathy Zhou <kz...@cmdservices.com>]

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:chris.cranford@setechusa.com]
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:fvillalba@madrid.bilbomatica.es] 
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:chris.cranford@setechusa.com] 
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:Leon.Rosenberg@friendscout24.de] 
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

> -----Ursprungliche Nachricht-----
> Von: CRANFORD, CHRIS [mailto:chris.cranford@setechusa.com]
> Gesendet: Montag, 14. Juni 2004 11:23
> An: 'user@struts.apache.org'
> 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: chris.cranford@setechusa.com



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
For additional commands, e-mail: user-help@struts.apache.org