setFetchSize with ResultSet.TYPE_SCROLL_INSENSITIVE - Mailing list pgsql-jdbc

From Alvaro Herrera
Subject setFetchSize with ResultSet.TYPE_SCROLL_INSENSITIVE
Date
Msg-id 20150219162723.GA2501@alvh.no-ip.org
Whole thread Raw
Responses Re: setFetchSize with ResultSet.TYPE_SCROLL_INSENSITIVE
List pgsql-jdbc
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


pgsql-jdbc by date:

Previous
From: Stephen Nelson
Date:
Subject: Re: release process
Next
From: Dave Cramer
Date:
Subject: Re: setFetchSize with ResultSet.TYPE_SCROLL_INSENSITIVE