JOOQ doesn't return auto generated value for normal column

Question

I have table user_profile, with 3 fields:

• id: UUID, primary key, not null, auto generated
• created: TIMESTAMP, not null, auto generated
• name: VARCHAR

Below is my code to insert a new row to the table.

// dsl is DslContext, which is a bean, injected by Spring Boot
dsl.newRecord(Tables.USER_PROFILE).apply {
    name = "My Name"
    insert()
// UserProfile is an immutable pojo class, generated by jooq.
}.into(UserProfile::class.java)

In the code above, "id" field (primary key) is updated to the pojo, while "created" field (normal field) is "null".

What is the "best way" to include the returning value for "created" field?

Answer 1

There are 2 flags governing this behaviour:

• Settings.returnIdentityOnUpdatableRecord, default true
• Settings.returnAllOnUpdatableRecord, default false

You want to set the second flag to true as well.