The following bug has been logged online:
Bug reference: 4483
Logged by: David Smiley
Email address: dsmiley(at)mitre(dot)org
PostgreSQL version: 8.3
Operating system: Mac OS X
Description: setAutoCommit false shouldn't be necessary for fetchSize
to work
Details:
No matter what is going on internally within the JDBC driver, I don't
believe disabling autoCommit should be necessary to benefit from the
fetchSize hint (i.e. cursors). As long as the user code hasn't iterated to
the end of the resultSet yet, the semantics of autoCommit are irrelevant.
References:
http://java.sun.com/javase/6/docs/api/java/sql/Connection.html#setAutoCommit
(boolean)
http://jdbc.postgresql.org/documentation/83/query.html#query-with-cursor