RE : Nmber of rows in a ResultSet - Mailing list pgsql-jdbc

From Xavier Bugaud
Subject RE : Nmber of rows in a ResultSet
Date
Msg-id 94BCF3512BFBD711B79D004005420B1F03F6D8@PMSERVER
Whole thread Raw
Responses Re: RE : Nmber of rows in a ResultSet  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
> On Fri, 9 Jan 2004, Kris Jurka wrote:
>
> > 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();') ?
>
> I don't see what's so wrong with rs.last() and rs.getRow().
>

Thank you for the response.

What is wrong with rs.last() and rs.getRow() is
- it requires scrollable cursors in order to get back to the first row
- it will certainly slow down the operation in case of huge amount of
rows (I don't known how the Postgres driver handle that, so maybe this
is wrong... I hope so)



Regards
--
Xavier Bugaud
www.gloptv.com


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: [BUGS] JDBC driver doesn't handle NaN values
Next
From: Kris Jurka
Date:
Subject: Re: [BUG] - Invalid UNICODE character sequence found