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] <javascript:>>: > >> 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] <javascript:>. >> 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.
