The following bug has been logged online: Bug reference: 4483 Logged by: David Smiley Email address: [EMAIL PROTECTED] 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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
