Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10
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: WhetherUpdatableRecordinstances should modify the record version prior to storing the record. This feature is independent of, but related to optimistic locking. -
updateRecordTimestamp: WhetherUpdatableRecordinstances 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.
Example 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
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!