|
The
problem may be in the SQL Statement itself. Try running the SQL
statement in SQLPlus (or whatever you us) to make sure the problem is not in the
statement.
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
|