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.
In response to
pgsql-jdbc by date
|Next:||From: Antonini Roberto||Date: 2004-08-30 16:08:24|
|Previous:||From: Antony Paul||Date: 2004-08-30 10:56:23|
|Subject: AutoCommit and SQLException|