one stage process
Parsing SQL: get SQL type (UPDATE), table (product), condition (wherename='TXC') and other related information.
Mirroring before query: Generate query statements and locate data according to the condition information obtained through analysis.
Execute business SQL: update the name of this record to 'GTS'.
Post-query mirroring: According to the results of the previous mirroring, locate the data through the primary key.
Insert the rollback log: combine the front and back mirror data and business SQL-related information into a rollback log record and insert it into the UNDO_LOG table.
Before submitting, register the branch with TC: Apply for the global lock of the record whose primary key value is equal to 1 in the product table.
Local transaction submission: The update of business data is submitted together with the UNDO LOG generated in the previous steps.
Report the result of local transaction submission to TC.
Last updated