Thank you Lukas It works well :)
2021년 10월 1일 금요일 오후 8시 11분 41초 UTC+9에 [email protected]님이 작성: > Hi Cheolho, > > There are some open issues related to using null values inside of row() > expressions, when jOOQ can't infer the data type even if intuitively, it > should work. The workaround is to wrap the null value in DSL.value(null, > dataType), to make sure the right data type is associated with the value. > > I hope this helps, > Lukas > > On Fri, Oct 1, 2021 at 1:08 PM Cheolho Jeon <[email protected]> wrote: > >> 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. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "jOOQ User Group" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/jooq-user/715359eb-c12b-4676-b671-fd57a6f20140n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/jooq-user/715359eb-c12b-4676-b671-fd57a6f20140n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/c111f2eb-a727-4bf9-b1a7-c3d74418432dn%40googlegroups.com.
