Bryan Pendleton <[EMAIL PROTECTED]> 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
