|previous : next|
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
Return all columns on store
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
When using the updatable records feature, jOOQ always fetches the generated identity value, if such a value is available and if the return identity on store feature is enabled (it is, by default).
The identity value is not the only value that is generated by default. Specifically, there may be triggers that are used for auditing or other reasons, which generate
LAST_UPDATE_BY values in a record. Users who wish to also automatically fetch these values after all
update() calls may do so by specifying the
returnAllOnUpdatableRecord setting. This setting depends on the availability of INSERT .. RETURNING,
UPDATE .. RETURNING, and
DELETE .. RETURNING statements, which are not available from all databases, in case of which a
refresh() call may be issued, creating a separate round trip to the server.
Settings settings = new Settings() .withReturnAllOnUpdatableRecord(true); // Defaults to false
Do you have any feedback about this page? We'd love to hear it!