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

Re: AutoCommit and SQLException

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Antony Paul <antonypaul24(at)hotmail(dot)com>
Cc: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: AutoCommit and SQLException
Date: 2004-08-30 11:31:42
Message-ID: 4133101E.1090401@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Antony Paul wrote:
> 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 ?

You have to roll it back yourself.

PostgreSQL will generate errors on subsequent queries in a transaction 
after an error (until you roll it back), but that's not necessarily true 
of other DBs.

-O

In response to

pgsql-jdbc by date

Next:From: Antonini RobertoDate: 2004-08-30 16:08:24
Subject: pq_recvbuf
Previous:From: Antony PaulDate: 2004-08-30 10:56:23
Subject: AutoCommit and SQLException

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