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
thefull result set... 

Reto

---- Dave Cramer <pg@fastcrypt.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@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
> >
> >