Re: Anyone using CachedRowSet

Thorbjørn,
Thanks! That's basically what I have done. What I have though is an
ArrayList<Object[]>. Where I store each row set in the object array and use
the results.getObject(i).

I then have some very generic getString, getObject, getBigDecimal, etc
methods to retrieve the data from the array list. I do use the table model,
in this case, to load the table.

It does work well, but like you said if the result set returns too many rows
there are some issues. I just wanted to make sure that there was not a
better way.

James R. Perkins


On Sat, Nov 8, 2008 at 1:53 AM, Thorbjørn Ravn Andersen <ravn@xxxxxxxxxx>wrote:

James Perkins skrev:

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.

If you do not want to use too much magic and you just need to present
the result as strings, you can always for a given single resultset row,
get all the "cells" as strings with resultSet.getString(i) (i=1..n) and
add them to an arraystring. You can then store each row (which is an
arraylist containing strings) in another arraylist so you have a list of
list of strings. This is easy to work with in the jtable model and will
work even with Java 1.3

Just be careful that you do not end up with enormeous resultsets :)

/Thorbjørn
--
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.