Hello, Thanks for your enquiry. I see that you've already discovered the relevant documentation about how to integrate PostgreSQL JSON data types into jOOQ. https://github.com/jOOQ/jOOQ/issues/3248#issuecomment-76142832 http://www.jooq.org/doc/latest/manual/code-generation/custom-data-type-bindings/
Right now, this is the only example that we have in the manual. We'll be adding more examples in the near future. If you have specific questions, just ask. We'll be more than happy to help Best Regards, Lukas 2015-02-26 10:06 GMT+01:00 <[email protected]>: > Hi Lukas. > Is there any news in this regards? > (Sorry if it was already discussed on the group) > > Thanks > > El martes, 11 de marzo de 2014, 11:49:42 (UTC+1), Lukas Eder escribió: >> >> Hi John, >> >> Thanks, that's what I had thought. This PGobject seems to be the >> PostgreSQL's JDBC driver's default dump for all sorts of vendor-specific >> types. >> I suspect the way forward for jOOQ here is to >> >> - Introduce support for a new SQLDataType.JSON type >> - Include a default, ASL 2.0 licensed JSON implementation in jOOQ >> (preferably one that implements javax.json) >> - Allow for overriding this implementation through converters >> >> This solution should also enable JSON storage in other databases, that do >> not natively support this data type. >> >> Cheers >> Lukas >> >> >> 2014-03-11 10:24 GMT+01:00 <[email protected]>: >> >>> I am using the below approach to directly insert json through spring >>> jdbc templates. >>> >>> PGobject jsonObject = new PGobject(); >>> jsonObject.setType("json"); >>> jsonObject.setValue(new Gson().toJson(attributes)); >>> String sql = "INSERT INTO table (id, details) values (?, ?)"; >>> new JdbcTemplate(dataSource).update(sql, "id", jsonObject); >>> >>> >>> Thanks, >>> John >>> >>> On Monday, March 10, 2014 12:41:38 PM UTC+5:30, John wrote: >>>> >>>> Hi, >>>> I just started using JOOQ in one of the project, i am not able to find >>>> out a way to insert a row which has a column of postgresql's json data >>>> type. Any help on this regard? >>>> >>>> Thanks, >>>> John >>>> >>> -- >>> 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. > -- 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.
