Re: setFetchSize with ResultSet.TYPE_SCROLL_INSENSITIVE

Hello

I made many tests since last week, and unfortunately I was wrong with my statement..

It seems that the description in the documentation is still right about setFetchSize: Unfortunately if you put the type TYPE_SCROLL_INSENSITIVE, fetch size will be completely ignored. The same applies to the parameter HOLD_CURSORS_OVER_COMMIT. I just had too much memory, so that I didn't recognized that the driver is actually fetching the full result set...

Reto

---- Dave Cramer <pg(at)fastcrypt(dot)com> schrieb:
> 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
> >
> >