Synchronizing database and non-database resources without a commit coordinator
A system to synchronize a database and a non-database resource includes an application to transmit a request to a service provider to perform an action. The service provider receives the request and performs the action, the action not being under commit coordination. The service provider further ins...
Gespeichert in:
Hauptverfasser: | , , , |
---|---|
Format: | Patent |
Sprache: | eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | A system to synchronize a database and a non-database resource includes an application to transmit a request to a service provider to perform an action. The service provider receives the request and performs the action, the action not being under commit coordination. The service provider further inserts an entry into an action-reversal table to reverse the action and makes the insertion permanent. The service provider, on behalf of the application, then deletes the entry from the action-reversal table. The application may then be configured to perform one of the following: (1) make the delete permanent by performing a COMMIT; and (2) roll back the delete by performing a ROLLBACK. At a later time, the service provider may reverse the action in the event the entry remains in the action-reversal table. Corresponding methods and articles of manufacture (i.e., computer-readable media) are also disclosed herein. |
---|