Re: setFetchSize with ResultSet.TYPE_SCROLL_INSENSITIVE

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(at)2ndquadrant(dot)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(dot)hodel(at)hispeed(dot)ch>
> To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
>