RE: Caching data from resultset

2004-06-16 Thread Viral_Thakkar
Should we need to store the X and Y values in session? -Original Message- From: Pilgrim, Peter [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 3:21 PM To: 'Struts Users Mailing List' Subject: RE: Caching data from resultset > -Original Message- > Fr

RE: Caching data from resultset

2004-06-16 Thread Freddy Villalba Arias
Hi, Yes, indeed. Postgres has something similar. Regards, Freddy. -Mensaje original- De: Pilgrim, Peter [mailto:[EMAIL PROTECTED] Enviado el: miércoles, 16 de junio de 2004 11:51 Para: 'Struts Users Mailing List' Asunto: RE: Caching data from resultset > -Ori

RE: Caching data from resultset

2004-06-16 Thread Pilgrim, Peter
> -Original Message- > From: Kies, Daniel [mailto:[EMAIL PROTECTED] > Sent: 14 June 2004 17:52 > To: 'Struts Users Mailing List' > Subject: RE: Caching data from resultset > > > I recently implemented pagination for resultsets using Oracle > 9i

RE: Caching data from resultset

2004-06-14 Thread Kies, Daniel
and 20 If you still have problems getting your query running, send it to me directly and I'll see if can't get it going. Dan -Original Message- From: CRANFORD, CHRIS [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 11:00 AM To: 'Struts Users Mailing List' Subject: RE:

RE: Caching data from resultset

2004-06-14 Thread Kies, Daniel
and 20 If you still have problems getting your query running, send it to me directly and I'll see if can't get it going. Dan -Original Message- From: CRANFORD, CHRIS [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 11:00 AM To: 'Struts Users Mailing List' Subject: RE:

RE: Caching data from resultset

2004-06-14 Thread CRANFORD, CHRIS
7; Subject: RE: Caching data from resultset I recently implemented pagination for resultsets using Oracle 9i. Instead of loading up the entire resultset into memory, I just queried based on the records that the user requested. 1) Before getting the records, I first counted the records that w

RE: Caching data from resultset

2004-06-14 Thread Kies, Daniel
al Message- From: CRANFORD, CHRIS [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 10:39 AM To: 'Struts Users Mailing List' Subject: RE: Caching data from resultset Not sure how much this is going to help because we're averaging about 15 seconds to transform a resultset of 1200 reco

RE: Caching data from resultset

2004-06-14 Thread CRANFORD, CHRIS
igned. -Original Message- From: CRANFORD, CHRIS [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 12:39 PM To: 'Struts Users Mailing List' Subject: RE: Caching data from resultset Not sure how much this is going to help because we're averaging about 15 seconds to transform

RE: Caching data from resultset

2004-06-14 Thread CRANFORD, CHRIS
for a project due tomorrow afternoon :-) Thanks Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 12:02 PM To: Struts Users Mailing List Subject: RE: Caching data from resultset Hmmm...maybe a RowSetDynaClass is what y

RE: Caching data from resultset

2004-06-14 Thread DGraham
OTECTED]> To 'Struts Users Mailing List' <[EMAIL PROTECTED]> cc Subject RE: Caching data from resultset Not a problem because I do have an OTN account.  But I guess the question is whether it will work with Oracle 8i or only 9? In the past what I have done is

RE: Caching data from resultset

2004-06-14 Thread CRANFORD, CHRIS
lity available using CachedResultSet (ocrs12.zip from oracle) via 8i database and jdk1.2? Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 11:07 AM To: Struts Users Mailing List Subject: RE: Caching data from resultset http://otn.orac

RE: Caching data from resultset

2004-06-14 Thread DGraham
;Struts Users Mailing List" <[EMAIL PROTECTED]> cc Subject RE: Caching data from resultset http://otn.oracle.com/software/tech/java/sqlj_jdbc/htdocs/jdbc9201.html ocrs12.zip appears to be a library containing Oracles imlementation of CachedResultSet and there is a JDK 1

RE: Caching data from resultset

2004-06-14 Thread DGraham
t; <[EMAIL PROTECTED]> 06/14/2004 09:54 AM Please respond to "Struts Users Mailing List" <[EMAIL PROTECTED]> To 'Struts Users Mailing List' <[EMAIL PROTECTED]> cc Subject RE: Caching data from resultset But CachedRowSet isn't available in

RE: Caching data from resultset - reply

2004-06-14 Thread Kathy Zhou
, 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 &g

RE: Caching data from resultset - reply

2004-06-14 Thread Kathy Zhou
, 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

RE: Caching data from resultset

2004-06-14 Thread CRANFORD, CHRIS
o: 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 s

RE: Caching data from resultset

2004-06-14 Thread Freddy Villalba Arias
I'm sorry, my reply should have been directed to Chris, not Leon. My apologies, Leon. Regards, Freddy. -Mensaje original- De: Freddy Villalba Arias Enviado el: lunes, 14 de junio de 2004 14:22 Para: Struts Users Mailing List Asunto: RE: Caching data from resultset Hi Leon, I su

RE: Caching data from resultset

2004-06-14 Thread Freddy Villalba Arias
unes, 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

RE: Caching data from resultset

2004-06-14 Thread CRANFORD, CHRIS
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