How to deal with the loss of communication during the rollback of a failed transaction? It is clear that there will be violations of the integrity of the database. How to deal with such situations? The bundle works through ORACLE + C # On the msdn site they write that it is necessary to catch exceptions when a transaction is rolled back, since errors may occur (for example, a disconnection). And they can really

  • And how will this affect the database? The transaction would still be rolled back entirely, as if no changes had been made at all - Mike
  • Do you mean when you call rollback, then at this time there is a connection break? - Stepan Kasyanenko
  • Yes, but the transaction is organized by the client and even if there is a loss of connection, is the rollback completion guaranteed? - Aleksandr Necheukhin
  • one
    @AleksandrNecheukhin A client process terminates abnormally, it leads to from Oracle docs - Vladislav Khapin

1 answer 1

Oracle docs

End of a Transaction
The transaction ends occurs:

...

A client process terminates abnormally , it can be followed by a table and the undo segment.

Those. technical problems with integrity should not be when the connection is broken