Обсуждение: setFetchSize with ResultSet.TYPE_SCROLL_INSENSITIVE
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 Hello According to the following link (https://jdbc.postgresql.org/documentation/head/query.html) setting the fetch size is onlypossible 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 forwardAND 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
Not exactly sure how this is a problem ? Seems like an undocumented feature.
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
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 > > > >