March 2020
Intermediate to advanced
534 pages
14h 15m
English
There are several system fields that are always created on all tables. One of which is RecVersion, which is used by Optimistic Concurrency (OCC). Optimistic concurrency is enabled by default on new tables. We select a record "for update" by adding a forUpdate clause to a select or while select statement, or by using the selectForUpdate(true) method that exists on all tables.
When we select a record for update, a physical lock is not placed on the record, and it is therefore possible for two different processes to select the same record for update.
As the record or records are read, they are read from the database into an internal record buffer. When the record is written back, it will check that ...
Read now
Unlock full access