Re: Number of rows in a ResultSet ?

> I need to know how many rows exist in a ResultSet. I've tried to use
> getFetchSize() method of ResultSet interface, but a message was
> displayed "this method is not yet implemented".
>
> Anyone can help me ?

You could use:
ResultSet.last();
int numberOfRows = ResultSet.getRow();

Now, my understanding of this area is a but sketchy, but I think that
most implementations of ResultSet do not get all of the results in one go
(like the PostgreSQL JDBC driver does), so getFetchSize() is not a safe
way of determining the number of results returned.

Or, you could do another query with count() in your sql..

Or (and I wouldn't do this without carefully looking at the jdbc spec),
you could just alter the getFetchSize() method
org.postgresql.jdbc2.ResultSet driver to look like:

public int getFetchSize() throws SQLException
{
return rows.size();
}

The choice is yours..

Michael Stephenson mstephenson(at)openworld(dot)co(dot)uk
Developer - Web Applications - Open World
Tel: +44 1225 444 950 Fax: +44 1225 336 738