Hi Pay, Thanks for your feedback. Much like PostgreSQL's json data type, the XML data type is currently not explicitly supported by jOOQ.
- xml: https://github.com/jOOQ/jOOQ/issues/584 - json: https://github.com/jOOQ/jOOQ/issues/2788 Unfortunately, even with JDBC, support for such types is non-trivial. You might get lucky by writing your own Converter and having jOOQ's code generator apply that Converter to relevant columns. The way I understand it, you will have to fetch / bind String values, and possibly XMLPARSE() them: http://stackoverflow.com/a/12051311/521799 I wonder if there is a way to operate on the standard JDBC java.sql.SQLXML? 2013/11/22 Pay Liu <[email protected]> > > Appendix: when I insert a xmlString into a XML column > > Hint: You will need to rewrite or cast the expression. > Position: 194 > at org.jooq.impl.Utils.translate(Utils.java:1121) > at > org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:462) > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:303) > at org.jooq.impl.InsertImpl.fetchOne(InsertImpl.java:505) > > -- > 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/groups/opt_out. > -- 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/groups/opt_out.
