Skip site navigation (1) Skip section navigation (2)

BUG #4483: setAutoCommit false shouldn't be necessary for fetchSize to work

From: "David Smiley" <dsmiley(at)mitre(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4483: setAutoCommit false shouldn't be necessary for fetchSize to work
Date: 2008-10-16 19:52:42
Message-ID: 200810161952.m9GJqg7p073870@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Arthur Knight HammerDate: 2008-10-17 16:23:06
Subject: 8.2.10 pg_ctl restart will stop but not start server
Previous:From: manish singhDate: 2008-10-16 16:33:14
Subject: BUG #4482: Segfault error 4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group