Re: Batch Processing - Autocommit

From: Kris Jurka <books(at)ejurka(dot)com>
To: Ron <rstpierre(at)syscor(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Batch Processing - Autocommit
Date: 2003-09-17 20:57:33
Message-ID: Pine.LNX.4.33.0309171653480.27960-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Ron 2003-09-17 21:07:45 Re: Batch Processing - Autocommit
Previous Message Ron 2003-09-17 19:12:28 Batch Processing - Autocommit