Re: Batch Processing - Autocommit - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Batch Processing - Autocommit
Date
Msg-id Pine.LNX.4.33.0309171653480.27960-100000@leary.csoft.net
Whole thread Raw
In response to Batch Processing - Autocommit  (Ron <rstpierre@syscor.com>)
Responses Re: Batch Processing - Autocommit  (Ron <rstpierre@syscor.com>)
List 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 by date:

Previous
From: Ron
Date:
Subject: Batch Processing - Autocommit
Next
From: Ron
Date:
Subject: Re: Batch Processing - Autocommit