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, ECDA Option for Oracle keeps no record of the statements that make up a transaction. As a result, when a failover occurs, the next statement in the transaction causes an error, which causes the entire transaction to fail.
In response, the ECDA Option for Oracle client must either issue a ROLLBACK, or disconnect and reconnect (perform an implicit ROLLBACK) before the transaction can be reapplied.
