Re: Anyone using CachedRowSet

Thanks for the information Joe Sam.

I haven't used it in a long time, but I came across some old code where I
was using it. I (now for my excuses ;-)) don't really have the time to fix
the code, so I was just curious.

So, for my benefit, what are better ways to cache (maybe bad terminology)
results from a query? I have create in a sense my own caching bean, but I
don't know if it's the correct solution either.

I created the caching bean due to my first Swing program. I created an
application to take an SQL statement, execute it, and then display the
results into a JTable. I did this by caching the result set objects into an
ArrayList.

Is there a better way to do this? I assume there is, but I'm just curious.

James R. Perkins


On Fri, Nov 7, 2008 at 12:04 PM, Joe Sam Shirah <joe_sam@xxxxxxxxxxxxx>wrote:

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
--

--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.