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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2010-09-01 08:26:41 | Re: JDBC: "transaction aborted" |
Previous Message | Fabien JALABERT | 2010-09-01 07:40:27 | Re: JDBC: "transaction aborted" |