Resultset alternative

[miche]

If I work with a ResultSet, I must leave open my statement because if
I close the statement, automatically close also the relative
ResultSet. What can I use if I don't want leave the statement open but
I want work totally disconnect?

Thanks in advance!
Miche!

 

[stefanomnn]

with jdbc 3.0 you can use CachedRowSet class, which provide you a
disconnected ResultSet. here's a snippet:

Statement stmt = con.createStatement();
ResultSet rs =  stmt.executeQuery(
              "SELECT COF_NAME, PRICE FROM COFFEES");
 CachedRowSet rset = new CachedRowSet();
 crset.populate(rs);
 rs.close();
 stmt.close();

if you can't, you could create a collection of Map, where a map is a
row.

Stefano

 

[miche]

stefanomnn ha scritto:

with jdbc 3.0 you can use CachedRowSet class, which provide you a
disconnected ResultSet. here's a snippet:

Statement stmt = con.createStatement();
ResultSet rs =  stmt.executeQuery(
"SELECT COF_NAME, PRICE FROM COFFEES");
CachedRowSet rset = new CachedRowSet();
crset.populate(rs);
rs.close();
stmt.close();

if you can't, you could create a collection of Map, where a map is a
row.

Stefano

Hi Stefano

You are very kind...
I can try your suggestion...

Thank you so mutch!
Michele

bye bye