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

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 (view raw or flat)
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

pgsql-jdbc by date

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

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