Hi Lukas!
Thank you for serving JOOQ.
I'm using JOOQ for project but I see a problem when I use update statement with DSL.row().
I want to use some nullable property(field) to DSL.row() on update statement like this:
update(CLAIM)
.set(
row(CLAIM.DESIRED_DATETIME, ...),
row(null as LocalDateTime?, ...)
)
...
But when I run this code I met this error:
Caused by: java.lang.IllegalArgumentException: Cannot encode null parameter of type java.lang.Object
at io.r2dbc.postgresql.codec.DefaultCodecs.encodeNull(DefaultCodecs.java:184)
I found that this code is run well:
update(CLAIM)
.set(
CLAIM.DESIRED_DATETIME, null as LocalDateTime?
)
...
But I want to set multiple nullable properties(fields) at once.
Can you tell me the way resolve this problem?
Thank you.
P.S All code is written by Kotlin.