Re: Batch Processing - Autocommit

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: Batch Processing - Autocommit
Дата
Msg-id Pine.LNX.4.33.0309171653480.27960-100000@leary.csoft.net
обсуждение исходный текст
Ответ на Batch Processing - Autocommit  (Ron <rstpierre@syscor.com>)
Ответы Re: Batch Processing - Autocommit
Список pgsql-jdbc

On Wed, 17 Sep 2003, Ron wrote:

> I am running postgres 7.4 and want the database to process a large
> number of transactions at once from a java application. I tried to set
> autocommit = false, but as of postgres 7.4 that is not possible.
>
>     java.sql.SQLException: ERROR:  SET AUTOCOMMIT TO OFF is no longer
> supported

You need to use the Connection's setAutoCommit method instead of issuing
the above SQL directly.  Auto commit support has been moved from the
backend into the various client libraries in 7.4.

Kris Jurka


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

Предыдущее
От: Ron
Дата:
Сообщение: Batch Processing - Autocommit
Следующее
От: Ron
Дата:
Сообщение: Re: Batch Processing - Autocommit