Обсуждение: Nmber of rows in a ResultSet

Поиск
Список
Период
Сортировка

Nmber of rows in a ResultSet

От
Xavier Bugaud
Дата:
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