Forums Register Login

Exhausted Resultset

+Pie Number of slices to send: Send
When I execute a query this message appears:
"Error Message: Exhausted Resultset". I'd like to know what make it happens.
Thanks.
+Pie Number of slices to send: Send
That usually happens when you try to read past the end of the resultset.

If you place your resultset reading code inside of a while (rs.next()) { } you should be fine.
+Pie Number of slices to send: Send
It means the Oracle result set you are using is closed.
For example, it will happen if you issue a query then close the
Statement before using the ResultSet. Open a
new statement before each request, then close it after use.
the following is from oracle technet site:
What does "Exhausted Resultset: prepare_for_new_get" means?
This error happens if you try to use a ResultSet after you close it. It also happens if you close the statement that created the ResultSet.
ResultSet rset = stmt.executeQuery ("select ROWID from EMP");
...
rset.close (); // or stmt.close ();
rset.getString (1);
Regards
Beksy
Surfs up space ponies, I'm making gravy without this lumpy, tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1053 times.
Similar Threads
exception java.sql.SQLException: Exhausted Resultset
exception java.sql.SQLException: Exhausted Resultset
error - exhausted result set
Exhausted Resultset
What doe this error message mean??
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 13:19:43.