Hi Madhu, Thanks for your message. You will need to configure a data type binding on your POSTGRES_TABLE1.REQUEST column through the code generator as explained here: https://www.jooq.org/doc/latest/manual/code-generation/custom-data-type-bindings
You can then bind any client representation to the PostgreSQL JSONB data type. I wouldn't use org.jooq.tools.json.JSONObject, if I were you, but some other third party JSON library. I hope this helps, Lukas On Sat, Nov 10, 2018 at 4:46 AM Madhu Mohan <[email protected]> wrote: > Hi Lukas, > When i tried with JOOQ, > myClass r = create.insertInto(POSTGRES_TABLE1) > .set(POSTGRES_TABLE1.CREATEDDATE, > currentTimestamp()) > .set(POSTGRES_TABLE1.REQUEST, > DSL.val(activity.request, JSONObject)) > .returning().fetchOne() > > In the table "POSTGRES_TABLE1" column "REQUEST" is jsonb data type. But > unable to insert data using JOOQ, getting the following error. > Error: > Type class org.jooq.tools.json.JSONObject is not supported in dialect > DEFAULT > > -- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
