How do I get the row count in JDBC?

by

You’re going to have to do this as a separate query, for example:

SELECT COUNT(1) FROM table_name

Some JDBC drivers might tell you but this is optional behaviour and, more to the point, the driver may not know yet. This can be due to how the query is optimised eg two example execution strategies in Oracle are to get all rows as quickly as possible or to get the first row as quickly as possible.

If you do two separate queries (one a count and the other the query) then you’ll need to do them within the same transaction. This will work well on Oracle but can be problematic on other databases (eg SQL Server will either show you uncommitted data or block on an external uncommitted update depending on your isolation level whereas Oracle supports an isolation level that gives you a transactionally consistent view of the data without blocking on external updates).

Normally though it doesn’t really matter how many rows there are. Typically this sort of query is either batch processed or paged and either way you have progress information in the form of rows loaded/processed and you can detect the end of the result set (obviously).

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 row count using ResultSet in Java?
  10. How to get the number of columns from a JDBC ResultSet?
  11. Convert a Result Set from SQL Array to Array of Strings
  12. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  13. Show JDBC ResultSet in HTML in JSP page using MVC and DAO pattern
  14. How to establish a connection pool in JDBC?
  15. java.sql.SQLException: – ORA-01000: maximum open cursors exceeded
  16. Cannot issue data manipulation statements with executeQuery()
  17. IO Error: The Network Adapter could not establish the connection
  18. Java JDBC Access denied for user [closed]
  19. Why does autoReconnect=true not seem to work?
  20. JDBC returning MySQLSyntaxError Exception with correct statement
  21. JDBC- Implementation of interfaces
  22. Get Number of Rows returned by ResultSet in Java
  23. com.mysql.jdbc.PacketTooBigException
  24. Where do I have to place the JDBC driver for Tomcat’s connection pool?
  25. How to execute multiple SQL statements from java
  26. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  27. Connection cannot be cast to oracle.jdbc.OracleConnection
  28. Why do we use a DataSource instead of a DriverManager?
  29. Do I need to close ‘PreparedStatement’? [closed]
  30. java.sql.SQLException: No database selected – why?

Leave a Comment