Re: Anyone using CachedRowSet

[Thorbjørn Ravn Andersen <ravn@xxxxxxxxxx>]

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