Re: Anyone using CachedRowSet

["Joe Sam Shirah" <joe_sam@xxxxxxxxxxxxx>]

   Hi James,

   I've used them, or tried to.  The real purpose I wanted it for was 
built-in optimistic concurrency, but I had to make workarounds for almost 
every operation because the implementation was so bad.  Actually, I should 
have jumped on the open source JDK 7 and made it right, but... (insert 
excuses here.)  That was 2005, but I don't see where any substantial (or 
maybe any) have been made.

   As to "is it still needed?"  I think it depends on your usage.  If you
are really looking to cache *data*, eight ball says odds are good there are
better ways.  If you really need to access the data as a rowset, but
disconnected, or have scrollability etc when the driver/database doesn't
provide it, and those kinds of reasons, then I'd say they definitely have a
place.  But there really should be better implementations in the standard
API.

   IMO, etc.


                                                        Joe Sam

Joe Sam Shirah -        http://www.conceptgo.com
conceptGO       -        Consulting/Development/Outsourcing
Java Filter Forum:       http://www.ibm.com/developerworks/java/
Just the JDBC FAQs: http://www.jguru.com/faq/JDBC
Going International?    http://www.jguru.com/faq/I18N
Que Java400?            http://www.jguru.com/faq/Java400

----- Original Message ----- 
From: "James Perkins" <jrperkinsjr@xxxxxxxxx>
To: "Java Programming on and around the iSeries / AS400"
<java400-l@xxxxxxxxxxxx>
Sent: Friday, November 07, 2008 11:50 AM
Subject: Anyone using CachedRowSet


> Hello All,
> I'm just curious to see if anybody is using the JSR-000114 JDBC(TM) Rowset
> Implementations?
>
> I have used this in the past, but is it still needed? Are there better
> way's
> to cache results?
>
> Thanks in advance,
> James R. Perkins
> --