Re: [cinjug-users] ResultSet closing prematurely

["Jason Kretzer/STAR BASE Consulting Inc." <JKretzer@xxxxxxxxxxxxxxx>]

Found it.  I was not aware that
you could not use the ResultSet as part of another query.

Inside the while loop, I was executing
another query with a call to rs.getString(1) in it and that caused the
exception.

Thanks all!

-Jason

"Jason Kretzer/STAR BASE Consulting Inc." <JKretzer@xxxxxxxxxxxxxxx>

05/20/2004 04:17 PM

To	users@xxxxxxxxxx
cc
Subject	[cinjug-users] ResultSet closing prematurely

I have a query that returns two records and using a standard while loop,
I get the records.  For some reason the loop is only entered once
and then I get the exception at the bottom on the second iteration.  The
exception references the while(rs.next()) 

Anyone know what could cause this? 




ResultSet rs = stmt.executeQuery("some_query");

while(rs.next()) 
{ 
        //do something with rs
} 




com.ibm.db2.jcc.b.SQLException: Invalid operation: result set closed