Oracle Corporation
HANDLING FAULTED DATABASE TRANSACTION RECORDS

Abstract:

Database transaction records that are received for committing data to a database may be associated with one or more validation tasks. When one of the validation tasks fails, the fault is detected and processing of the transaction record is halted. Instead of terminating the transaction record and requiring the submitting system to reinitiate the process, the system may use a mapping table to determine whether an automatic resubmission is possible. A new transaction record may be generated that copies an invocation context from the original transaction record, and portions of the transaction payload may be copied to the new transaction record with changes that ensure the new transaction record will pass the validation tasks. The new transaction record can then be submitted through the same interface that received the original transaction record, and the original transaction record can be removed from a transaction data store.