Kbase P122093: Can a record lock be released within a transaction ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/09/2008 |
|
Status: Verified
GOAL:
Can a record lock be released within a transaction ?
GOAL:
Is it possible to release a record lock within a transaction?
GOAL:
Why is it not possible to release a lock within a transaction?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Versions
FIX:
It is not possible to release locks within a transaction.
The RELEASE statement releases /buffers/ not locks.
The reason that the locks are not released within a transaction is because that would violate the atomicity, consistency, and isolation properties of transactions - three of the four properties (durability is the fourth property).
If records locks were released within a transaction for rows that have been updated, it would no longer be possible to undo the transaction, and crash recovery would also not work anymore.