AutoCommit and SQLException

From: "Antony Paul" <antonypaul24(at)hotmail(dot)com>
To: "pgsql-jdbc" <pgsql-jdbc(at)postgresql(dot)org>
Subject: AutoCommit and SQLException
Date: 2004-08-30 10:56:23
Message-ID: BAY15-DAV15d2DpZtYo00029474@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi all,
What happens to transaction when an SQL exception is thrown while it is
in a transaction. Does the connection automatically rollbacks the
transactions or we have to roll back it ?. I am using PreparedStatements and
Statements and no stored procedures.
Is there any specification for the behaviour of connection pools ?.

rgds
Antony Paul

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2004-08-30 11:31:42 Re: AutoCommit and SQLException
Previous Message Luke (Terry) Vanderfluit 2004-08-29 20:53:41 Re: JNDI Datasource configuration