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

Поиск
Список
Период
Сортировка
От David Smiley
Тема BUG #4483: setAutoCommit false shouldn't be necessary for fetchSize to work
Дата
Msg-id 200810161952.m9GJqg7p073870@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4483: setAutoCommit false shouldn't be necessary for fetchSize to work  (Kris Jurka <books@ejurka.com>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4483
Logged by:          David Smiley
Email address:      dsmiley@mitre.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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Arthur Knight Hammer
Дата:
Сообщение: 8.2.10 pg_ctl restart will stop but not start server
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 8.2.10 pg_ctl restart will stop but not start server