Transaction Terms

 <     >         Configuration       Start Transaction       Table of Contents

 

Dirty Read:  Transaction 1 changes a row.  Transaction 2 reads the changed row before transaction 1 commits the change.  If transaction 1 rolls back the change, transaction 2 will have read a row that is considered to have never existed.

Nonrepeatable Read:  Transaction 1 reads a row.  Transaction 2 updates or deletes that row and commits this change.  If transaction 1 attempts to reread the row, it will receive different row values or discover that the row has been deleted.

Phantom:  Transaction 1 reads a set of rows that satisfy some search criteria.  Transaction 2 inserts a row that matches the search criteria.  If transaction 1 re-executes the statement that read the rows, it receives a different set of rows.

© Copyright 2000-2020 Micro Focus or one of its affiliates.