Thread: Nmber of rows in a ResultSet

Nmber of rows in a ResultSet

From
Xavier Bugaud
Date:
Hi all,

JDBC does not allow to directly retrieve the number of rows in a ResultSet.
However, in old Postgres JDBC drivers (pgjdbc2.jar), the number of rows
contained in a ResultSet could be obtained by calling getFetchSize().

In the last JDBC drivers, is there a means to get the number of rows
directly (without using 'SELECT COUNT(*)' or 'rs.last();rs.getrow();') ?

Thank you in advance.

Regards
--
Xavier Bugaud
www.gloptv.com