6 messages in com.mysql.lists.javaRe: Using Multiple (Nested) ResultSets
FromSent OnAttachments
F. Andy Seidl04 Sep 2002 06:24 
Mark Matthews04 Sep 2002 07:26 
Jasper Fontaine04 Sep 2002 07:55 
Mark Matthews04 Sep 2002 08:44 
F. Andy Seidl04 Sep 2002 08:46 
Jasper Fontaine04 Sep 2002 08:58 
Subject:Re: Using Multiple (Nested) ResultSets
From:Mark Matthews (ma@mysql.com)
Date:09/04/2002 08:44:38 AM
List:com.mysql.lists.java

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