db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: Should be a statement with error allowed to do a rollback of the active transaction
Date Thu, 07 Dec 2006 08:46:30 GMT
Bryan Pendleton <bpendleton@amberpoint.com> writes:

>> The key question is whether the statement with error should (or
>> could) rollback the active transaction? 
> Does this same situation arise with an embedded configuration? If so, how
> does the embedded engine handle your test case?

With an embedded configuration, the result of executing the statement
which fails is exactly the same as not executing the statement. That
is, nothing is changed in the database regardless of autocommit mode
and whether commit() is called. Also, it doesn't roll back any other
uncommitted changes made by that transaction.

Knut Anders

View raw message