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

Re: JDBC: "transaction aborted"

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Fabien JALABERT <fabien(dot)jalabert(at)laposte(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC: "transaction aborted"
Date: 2010-09-01 08:18:25
Message-ID: 4C7E0C51.9010708@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-jdbc
On 01/09/10 15:40, Fabien JALABERT wrote:
> Hello, if I turn on autocommit, will I be able to process transactions
> with begin/commit/rollback as before ?

If you mean issuing explicit "BEGIN", "COMMIT" and "ROLLBACK" statements
as SQL text through the JDBC driver ... honestly, I'm not sure. It's not
really how the JDBC interface is intended to work.

Typically when using JDBC you would let the driver take care of this.
You call

  conn.setAutoCommit(false);

... to open a transaction. Any work between then and a subsequent:

  conn.commit()

or

  conn.rollback()

is done in the transaction.



-- 
Craig Ringer

Tech-related writing: http://soapyfrogs.blogspot.com/

In response to

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2010-09-01 08:26:41
Subject: Re: JDBC: "transaction aborted"
Previous:From: Fabien JALABERTDate: 2010-09-01 07:40:27
Subject: Re: JDBC: "transaction aborted"

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