Re: JDBC: "transaction aborted" - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: JDBC: "transaction aborted"
Date
Msg-id 4C7E0E41.3080302@opencloud.com
Whole thread Raw
In response to Re: JDBC: "transaction aborted"  (Fabien JALABERT <fabien.jalabert@laposte.net>)
List pgsql-jdbc
Fabien JALABERT wrote:
> Hello, if I turn on autocommit, will I be able to process transactions
> with begin/commit/rollback as before ?

"Maybe" - but you shouldn't be doing that anyway. The JDBC model expects
that to do explicit transaction demarcation, you turn off autocommit and
use methods on Connection to do commit/rollback. You shouldn't be
issuing queries with explicit BEGIN/COMMIT/ROLLBACK.

see e.g.
http://download.oracle.com/javase/1.3/docs/guide/jdbc/getstart/connection.html#1004665

-O

pgsql-jdbc by date:

Previous
From: Fabien JALABERT
Date:
Subject: Re: JDBC: "transaction aborted"
Next
From: Craig Ringer
Date:
Subject: Re: JDBC: "transaction aborted"