java.sql.SQLException: Exhausted Resultset

by

I’ve seen this error while trying to access a column value after processing the resultset.

if (rs != null) {
  while (rs.next()) {
    count = rs.getInt(1);
  }
  count = rs.getInt(1); //this will throw Exhausted resultset
}

Hope this will help you 🙂

More Related Contents:

  1. Using setDate in PreparedStatement
  2. How to enable logging for SQL statements when using JDBC
  3. Getting output from dbms_output.get_lines using JDBC
  4. JDBC ResultSet get columns with table alias
  5. Getting an exception ORA-00942: table or view does not exist – when inserting into an existing table
  6. How to get the insert ID in JDBC?
  7. Is java.sql.Timestamp timezone specific?
  8. java.util.Date vs java.sql.Date
  9. java.sql.SQLException: – ORA-01000: maximum open cursors exceeded
  10. How to connect to Oracle using Service Name instead of SID
  11. How can I get the SQL of a PreparedStatement?
  12. right syntax to use near ‘?’
  13. Running a .sql script using MySQL with JDBC
  14. How to call oracle stored procedure which include user-defined type in java?
  15. Oracle JDBC intermittent Connection Issue
  16. Java – Can’t use ResultSet after connection close
  17. Timezones in SQL DATE vs java.sql.Date
  18. SQL prepared statement how to select via multiple possible menu selections?
  19. Class.forName(JDBC_DRIVER) no longer needed?
  20. MyBatis Batch Insert/Update For Oracle
  21. Java JDBC – How to connect to Oracle using tnsnames.ora
  22. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  23. ojdbc14.jar vs. ojdbc6.jar
  24. Java – Storing SQL statements in an external file [closed]
  25. Connection timeout for DriverManager getConnection
  26. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  27. MS SQL Exception: Incorrect syntax near ‘@P0’
  28. PreparedStatement and setTimestamp in oracle jdbc
  29. Iterating a ResultSet using the JDBC for Oracle takes a lot of time about 16s?
  30. Database independence through JDBC in java

Leave a Comment