A cachedrowset is a wonderful tool. The only problem is that its still in
development over at sun. As a result I would caution against its use in a
production enviroment.
Now the best use of the cacherowset comes when it is used in conjunction
with connectionpooling. You make a quick connection. Dump your data into the
cached row set. Close your connection. Then you pass the cachedrowset to
another object to handle the data. This way you minimize your time connected
to the database and can easily pass your data as a complete object. (note
this won't work with a result set since you are only pointing to one row at
a time and you have a presistant dataconnection.)
Hope this helps.
Casey Kochmer
[EMAIL PROTECTED]
>From: Robert Nicholson <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: CachedRowSet
>Date: Thu, 8 Jun 2000 05:10:03 -0700
>
>In addition is anybody using cursors to do "paging?"
>
>-----Original Message-----
>From: A mailing list about Java Server Pages specification and reference
>[mailto:[EMAIL PROTECTED]]On Behalf Of G Ramesh [Support]
>Sent: Friday, September 25, 1998 4:44 AM
>To: [EMAIL PROTECTED]
>Subject: CachedRowSet
>
>
>hi,
>
>Could any one, explain me with an example the use of CachedRowSet.
>
>regards,
>Ramesh
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
