Jasper Fontaine wrote:
hi
you should see the resultset-object as a collection of
references/pointers to the database, fields in the database, the cursor,
etc. This means that once you reuse, close or otherwise decouple the
connection from the first resultset, the data you wanted to read from
that resultset isn't readable anymore.
So, if you really need to (if you can't solve this with a join or
group/order by), you should call the other query using a different
connection.
hope this helps
This isn't totally correct. You can have multiple open ResultSets
per-connection, just not per-Statement (this will change in JDBC-3.0 for
some databases).
-Mark