Hi All,
My java application executes one stored procedure that returns two resultsets and then deal with data. The code actually is very simple
Statement stmt = con.createStatement(); con is database connection
ResultSet rs = stmt.getResultSet();
//Do something
rs.close();
rs = stmt.getResultSet();
//Do something
Then I got the error: The result set is closed.
The code worked well with jdbc sql server 2000 driver.
Thanks for your help.
Eric
Hello lxiao,
The syntax for getting the second result set is
if(stmt.getMoreResults())
stmt.getResultSet();
Keep in mind that the getMoreResults() methods takes multiple arguments which controls how visited result sets should persist. Those flags are:
CLOSE_CURRENT_RESULT
CLOSE_ALL_RESULTS
You can find more information about using multiple result sets objects at the following site http://msdn2.microsoft.com/en-us/library/ms378758.aspx
Regards,
Jaaved Mohammed
No comments:
Post a Comment