Re: setFetchSize with ResultSet.TYPE_SCROLL_INSENSITIVE - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: setFetchSize with ResultSet.TYPE_SCROLL_INSENSITIVE
Date
Msg-id CADK3HH+YhbLpo7ZdTUSHJPEAUtu=jTFXN76S+UfmTVHiDSdYqA@mail.gmail.com
Whole thread Raw
In response to setFetchSize with ResultSet.TYPE_SCROLL_INSENSITIVE  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: setFetchSize with ResultSet.TYPE_SCROLL_INSENSITIVE  (<reto.hodel@hispeed.ch>)
List pgsql-jdbc
Not exactly sure how this is a problem ? Seems like an undocumented feature.

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On 19 February 2015 at 11:27, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
I rejected this moderated message to pgsql-general by mistake, so here's
a re-post to pgsql-jdbc.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


---------- Forwarded message ----------
From: <reto.hodel@hispeed.ch>
To: pgsql-general@postgresql.org
Cc: 
Date: Thu, 19 Feb 2015 10:23:47 +0100
Subject: setFetchSize with ResultSet.TYPE_SCROLL_INSENSITIVE
Hello

According to the following link (https://jdbc.postgresql.org/documentation/head/query.html) setting the fetch size is only possible if ResultSet type is set to ResultSet.TYPE_FORWARD_ONLY.

However, I'm not facing any problems when setting the type to ResultSet.TYPE_SCROLL_INSENSITIVE: I'm able to move forward AND backwards in the result set, yet fetch size still working...

Am I missing something here or is the description outdated / not counting for all driver versions?

PS: I'm using JDBC driver 9.3 1100

Thanks



--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc


pgsql-jdbc by date:

Previous
From: Alvaro Herrera
Date:
Subject: setFetchSize with ResultSet.TYPE_SCROLL_INSENSITIVE
Next
From: Albe Laurenz
Date:
Subject: Re: SSL renegotiation is broken