struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amleto Di Salle" <>
Subject R: Caching data from resultset
Date Mon, 14 Jun 2004 12:28:36 GMT
you can use the Value List Handler design pattern.
for an overview.

See for
an implementation. I never used it but it is seems very good.

If you will use it please give us some feedback!


-----Messaggio originale-----
Inviato: lunedì 14 giugno 2004 13.45
A: 'Struts Users Mailing List'
Oggetto: 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 [] 
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.


> -----Urspr√ľngliche Nachricht-----
> Gesendet: Montag, 14. Juni 2004 11:23
> An: ''
> 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
> 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:

To unsubscribe, e-mail:
For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message