Queries returning multiple result sets

by

Correct code to process multiple ResultSets returned by a JDBC statement:

PreparedStatement stmt = ...;
boolean isResultSet = stmt.execute();

int count = 0;
while(true) {
    if(isResultSet) {
        rs = stmt.getResultSet();
        while(rs.next()) {
            processEachRow(rs);
        }

        rs.close();
    } else {
        if(stmt.getUpdateCount() == -1) {
            break;
        }

        log.info("Result {} is just a count: {}", count, stmt.getUpdateCount());
    }

    count ++;
    isResultSet = stmt.getMoreResults();
}

Important bits:

  • getMoreResults() and execute() return false to indicate that the result of the statement is just a number and not a ResultSet.
  • You need to check stmt.getUpdateCount() == -1 to know if there are more results.
  • Make sure you either close the result sets or use stmt.getMoreResults(Statement.CLOSE_CURRENT_RESULT)

More Related Contents:

  1. Hours and seconds are lost when storing a date in the database [closed]
  2. Simulate Result set closing failed [closed]
  3. How to get the insert ID in JDBC?
  4. Multiple queries executed in java in single statement
  5. Insert & fetch java.time.LocalDate objects to/from an SQL database such as H2
  6. java.util.Date vs java.sql.Date
  7. Efficient way to do batch INSERTS with JDBC
  8. How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?
  9. How do I get the size of a java.sql.ResultSet?
  10. How can I get the SQL of a PreparedStatement?
  11. What is the best approach using JDBC for parameterizing an IN clause? [duplicate]
  12. How does a PreparedStatement avoid or prevent SQL injection?
  13. Variable column names using prepared statements
  14. MySQL and JDBC with rewriteBatchedStatements=true
  15. right syntax to use near ‘?’
  16. java.sql.SQLException: Exhausted Resultset
  17. JDBC Pagination
  18. How to enable logging for SQL statements when using JDBC
  19. org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
  20. handling DATETIME values 0000-00-00 00:00:00 in JDBC
  21. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  22. JDBC ResultSet get columns with table alias
  23. Class.forName(JDBC_DRIVER) no longer needed?
  24. dll missing in JDBC
  25. Java – Storing SQL statements in an external file [closed]
  26. Inserting null to an Integer column using JDBC
  27. How to use prepared statement for select query in Java?
  28. MS SQL Exception: Incorrect syntax near ‘@P0’
  29. Database independence through JDBC in java
  30. Searching between dates in SQL with JDBC?

Leave a Comment