Problem in running one resultset into another

[arun mahajan]

I was trying for the following code but it runs one time and gives error after tha:

Statement st1 = conn.createStatement();
Statement st2 = conn.createStatement();
ResultSet rs1 = st1.executeQuery("select client from clienttable");
ResultSet st2=null;
while(rs1.next())
{
String cl = rs1.getString("client");
rs2 = st2.executeQuery("select subclient from subtable where client='"+cl+"'");
if(rs2.next())
{
//do something
}
}

it runs for one time and than gives error:
java.sql.sqlException Object has been closed
I am trying it with JRUN 3.1 and java 1.3
When I tried debug I found that at the end of first run:
1. conn was available
2. rs1 and rs2 was available
3. st1 and st2 was available
To try for workaround when I created two connection separately it runs very well.
I tried finding the reason for this behaviour in API but failed. Am I missing something on API?
can somebody please explain this
[ July 29, 2002: Message edited by: arun mahajan ]

[Dave Vick]

Moving this to JDBC