Re: [cinjug-users] ResultSet closing prematurely

[Greg Williams <greg@xxxxxxxxxxxxxxxx>]

I know this seems like the obvious, but check for an misplaced call to rs.close() within your while loop.  We've all made simple mistakes like this that drive us nuts.

Greg

Jason Kretzer/STAR BASE Consulting Inc. wrote:

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