Re: [INTERFACES] JDBC line count in query result

On Tue, 4 Aug 1998, Bernhard Ertl wrote:

> If I do a query with psql there is the number of returned lines at the
> end.
> Is this also, if I do a query via jdbc and can I access this number
> before I process the results??

Not before you process the results.

This is an age old question with JDBC (includes why there isn't a standard
way of going backwards in a ResultSet - I haven't looked at the JDBC 2
spec but it may be in there...).

The problem is that most databases don't know how many rows are to be
returned to the client, until they have finished sending it.

It's basically a performance thing.

The only way to know how many are returned is to count the results your
self while reading the ResultSet.

--
Peter T Mount peter(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)net
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres