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