Hello Oliver and thanks a lot for answering,
> Either you can use two queries, or use a scrollable ResultSet and call
> ResultSet.last() / ResultSet.getRow(). The second approach causes the
> entire ResultSet to be loaded into the Java heap, though, so it's not so
> good for large results.
Currently I use the last()/getRow approach but as you confirmed this
approach does exactly what I don't want - to transfer the whole
selection between server and client.
Isn't there a workarround for this, maybe setting the fetch-size
(default set to 0)?
Thx, lg Clemens
In response to
pgsql-jdbc by date
|Next:||From: rstepha1||Date: 2005-08-29 14:09:19|
|Previous:||From: Arcadius A.||Date: 2005-08-29 03:34:02|
|Subject: Re: implementing asynchronous notifications PLEASE CONFIRM MY|