How to get the size of a ResultSet

Question

I am using the following query :

ResultSet resultset = prepraparedStatement.executeQuery();
int rowCount = resultSet.getFetchSize();

Does this work for getting the row count from a particular table?

Possible duplicate of [How do I get the size of a java.sql.ResultSet?](https://stackoverflow.com/questions/192078/how-do-i-get-the-size-of-a-java-sql-resultset) — theBrainyGeek, Nov 01 '17 at 20:11
An option would be to do a count(*) in your query and retrieve the value in your resultset — alainlompo, Nov 01 '17 at 20:12
Here is the documentation: https://docs.oracle.com/cd/E11882_01/java.112/e16548/resltset.htm#JJDBC28621 — Jacob H, Nov 01 '17 at 20:17

score 0 · Accepted Answer · answered Nov 01 '17 at 20:16

0

ResultSet.getFetchSize() doesn't return the number of results. JDBC 2.0 also allows you to specify the number of rows fetched with each database round trip for a query, and this number is referred to as the fetch size. You can read about it here

And about getting number of rows in result set you can try

int size= 0;  
if (resultSet!= null)   
{  
  resultSet.beforeFirst();  
  resultSet.last();  
  size = resultSet.getRow();  
}

answered Nov 01 '17 at 20:16

Muhammad Usman

10,039
22
39

Can I use `select count(*) from ` .. Will return a integer value? – Tapajyoti Giri Nov 01 '17 at 20:24
1

yes. Executing `select count(*) as totalRows from your_table` will give you `totalRows` in the `resultset`. Then you can get its value and it'll be total number of rows in the table. Make sense right ? – Muhammad Usman Nov 01 '17 at 20:27
The problem is that row count cannot be assumed to be accurate, especially if the table is accessed by more than one process. – Stavr00 Nov 01 '17 at 20:31
@Stavr00 Yes. that's why there are `Transactions` in `Sql` – Muhammad Usman Nov 01 '17 at 20:33

How to get the size of a ResultSet

1 Answers1