In this case, user may have troubles - for example when executing an sql
script through ij with autocommit off - the part of the transaction code
would be rollbacked and part of the code will be committed by the
following commit.
When an error is produced by the transaction transaction may get to the
abort state and the following commit or rollback will always perform a
rollback of the transaction. This ensures that the whole transaction
would be rollbacked. The statements following after the statement with
the error will always throw an exception (something like the
"Transaction is in abort state").
Cheers
Julo
Daniel John Debrunner wrote:
Some exceptions are transaction level, such as deadlock or lock
timeout, thus an error from a statement can rollback the transaction.
