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
On Monday, 8 May 2017 12:24:21 UTC+8, Daniel Einspanjer wrote:
>
> I was struggling a bit with this over the weekend. FOO is a table with a
> column BAR which is a JSONB type field.
> I have the generator hooked up with Gson and the signature for FOO.BAR is
> a JsonElement.
>
> For an example, a row in the table might have the jsonb value for bar:
> {"a": 1, "b": 2}
> And my sourceKey JsonObject would be {"b": 2}
>
> Kept getting errors such as:
> WARN Caused by: org.jooq.exception.SQLDialectNotSupportedException: Type
> class com.google.gson.JsonObject is not supported in dialect DEFAULT
>
> I tried a few different ways:
> .where(DSL.sql("{0} @> {1}", FOO.BAR,
> DSL.val(sourceKey)))
>
> .where(DSL.sql("{0} @> {1}", FOO.BAR,
> DSL.val(sourceKey)))
>
> .where(DSL.sql("{0} @> {1}::jsonb", FOO.BAR,
> DSL.val(sourceKey.toString())))
>
--
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.
