Available in versions: Dev (3.20)
This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
Computed column activation
Applies to ❌ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
Client side computed columns including audit columns are a useful feature to replace server side computed columns where the computational expression is dynamic, or uses some advanced jOOQ feature like implicit JOIN, or if the RDBMS does not support the feature.
In some cases, users may wish to deactivate the feature for the scope of a few individual queries, e.g. to load data into a table where computed values have already been provided.
Example configuration
Settings settings = new Settings()
.withComputedOnClientVirtual(false) // Defaults to true
.withComputedOnClientStored(false); // Defaults to true
In a lot of cases, it doesn't suffice to turn off the client side computed columns, but if data needs to be inserted / updated into these columns, then the readonly column feature may also have to be deactivated!
Example configuration, including readonly column feature
Settings settings = new Settings()
.withComputedOnClientStored(false) // Defaults to true
.withReadonlyInsert(WRITE) // Defaults to IGNORE
.withReadonlyUpdate(WRITE) // Defaults to IGNORE
.withReadonlyTableRecordInsert(WRITE) // Defaults to IGNORE
.withReadonlyUpdatableRecordUpdate(WRITE); // Defaults to IGNORE
Feedback
Do you have any feedback about this page? We'd love to hear it!