Available in versions: Dev (3.19) | Latest (3.18) | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 | 3.9
Optimistic Locking
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
There are two settings governing the behaviour of the jOOQ optimistic locking feature:
-
updateRecordVersion: Whether UpdatableRecord instances should modify the record version prior to storing the record. This feature is independent of, but related to optimistic locking. -
updateRecordTimestamp: Whether UpdatableRecord instances should modify the record timestamp prior to storing the record. This feature is independent of, but related to optimistic locking. -
executeWithOptimisticLocking: This allows for turning off the feature entirely. -
executeWithOptimisticLockingExcludeUnversioned: This allows for turning off the feature for updatable records who are not explicitly versioned.
Programmatic configuration
Settings settings = new Settings()
.withUpdateRecordVersion(true) // Defaults to true
.withUpdateRecordTimestamp(true) // Defaults to true
.withExecuteWithOptimisticLocking(true) // Defaults to false
.withExecuteWithOptimisticLockingExcludeUnversioned(false); // Defaults to false
XML configuration
<settings xmlns="http://www.jooq.org/xsd/jooq-runtime-3.12.4.xsd"> <updateRecordVersion>true</updateRecordVersion> <updateRecordTimestamp>true</updateRecordTimestamp> <executeWithOptimisticLocking>true</executeWithOptimisticLocking> <executeWithOptimisticLockingExcludeUnversioned>false</executeWithOptimisticLockingExcludeUnversioned> </settings>
For more details, please refer to the manual's section about the optimistic locking feature.
Feedback
Do you have any feedback about this page? We'd love to hear it!