> 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:
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
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
In response to
pgsql-interfaces by date
|Next:||From: Peter T Mount||Date: 2001-01-18 15:23:07|
|Subject: Re: Number of rows in a ResultSet ?|
|Previous:||From: The Hermit Hacker||Date: 2001-01-18 13:53:14|
|Subject: Re: [RFC] Proposed split of -interfaces list ...|