Re: NullPointerException when calling ResultSet.absolute(int) - Mailing list pgsql-jdbc

From Clemens Eisserer
Subject Re: NullPointerException when calling ResultSet.absolute(int)
Date
Msg-id 194f625505082904281f3ca75@mail.gmail.com
Whole thread Raw
In response to Re: NullPointerException when calling ResultSet.absolute(int)  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: NullPointerException when calling ResultSet.absolute(int)  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: Peter Wilkins
Date:
Subject: username and password for postgresql jdbc FTP site
Next
From: Kris Jurka
Date:
Subject: Re: username and password for postgresql jdbc FTP site