Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 30 Aug 2004 23:31:42 +1200
- Message-id: <4133101E.1090401@opencloud.com> <text/plain>
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
- References:
- AutoCommit and SQLException
- From: Antony Paul
- AutoCommit and SQLException
- Prev by Date: AutoCommit and SQLException
- Next by Date: pq_recvbuf
- Previous by thread: AutoCommit and SQLException
- Next by thread: pq_recvbuf
- Indexes: