Re: AutoCommit and SQLException

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