How to get row count using ResultSet in Java?

by

If you have access to the prepared statement that results in this resultset, you can use

connection.prepareStatement(sql, 
  ResultSet.TYPE_SCROLL_INSENSITIVE, 
  ResultSet.CONCUR_READ_ONLY);

This prepares your statement in a way that you can rewind the cursor. This is also documented in the ResultSet Javadoc

In general, however, forwarding and rewinding cursors may be quite inefficient for large result sets. Another option in SQL Server would be to calculate the total number of rows directly in your SQL statement:

SELECT my_table.*, count(*) over () total_rows
FROM my_table
WHERE ...

More Related Contents:

  1. How do I get the size of a java.sql.ResultSet?
  2. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  3. When to close Connection, Statement, PreparedStatement and ResultSet in JDBC
  4. JDBC driver throws “ResultSet Closed” exception on empty ResultSet
  5. JDBC ResultSet get columns with table alias
  6. Execute anonymous pl/sql block and get resultset in java
  7. ResultSet: Retrieving column values by index versus retrieving by label
  8. ResultSet.getString(1) throws java.sql.SQLException: Invalid operation at current cursor position
  9. How to get the number of columns from a JDBC ResultSet?
  10. How do I get the row count in JDBC?
  11. Convert a Result Set from SQL Array to Array of Strings
  12. Multiple queries executed in java in single statement
  13. Find Oracle JDBC driver in Maven repository
  14. How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?
  15. Is it possible to specify the schema when connecting to postgres with JDBC?
  16. Named parameters in JDBC [duplicate]
  17. Get query from java.sql.PreparedStatement [duplicate]
  18. How does a PreparedStatement avoid or prevent SQL injection?
  19. ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long on connect to MySQL
  20. ResultSet to Pagination
  21. No suitable driver found for ‘jdbc:mysql://localhost:3306/mysql [duplicate]
  22. How to get a value from the last inserted row? [duplicate]
  23. SQL Server JDBC Error on Java 8: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
  24. Difference between Oracle jdbc driver classes?
  25. Retrieve an Image stored as BLOB on a MYSQL DB
  26. Spring-Boot: How do I set JDBC pool properties like maximum number of connections?
  27. Call an Oracle function from Java
  28. Does a ResultSet load all data into memory or only when requested?
  29. Glassfish Admin Console throws java.lang.IllegalStateException when creating JDBC Pool
  30. Stumped SQL Exception for JDBC

Leave a Comment