Oracle TAF does not automatically fail over DML transaction statements, such as INSERT, UPDATE, or DELETE. Because the ECDA Option for Oracle is basically a passthrough gateway, it does not keep track of any transaction boundaries; therefore, it has no knowledge of all of the statements that make up the transaction. As a result, when a failover has occurred, the next statement in the transaction will cause an error, causing the entire transaction to fail.
In response, the ECDA Option for Oracle client will need either to issue a ROLLBACK or to disconnect and reconnect (perform an implicit ROLLBACK) before the transaction can be reapplied.
