Thanks Lukas, Understand. Thanks for replying.
For now, I'm not familiar with handling xml datatype and its relevant function...so I will use text Datatype instead of XML Datatype. thanks again. - Pay Lukas Eder於 2013年11月22日星期五UTC+8下午5時08分51秒寫道： > > 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<https://www.google.com/url?q=https%3A%2F%2Fgithub.com%2FjOOQ%2FjOOQ%2Fissues%2F584&sa=D&sntz=1&usg=AFQjCNEfMZeFqVug8Kz-XVi7HC7_lTgohg> > - json: > https://github.com/jOOQ/jOOQ/issues/2788<https://www.google.com/url?q=https%3A%2F%2Fgithub.com%2FjOOQ%2FjOOQ%2Fissues%2F2788&sa=D&sntz=1&usg=AFQjCNEFC31OvSJ7C06ITg7xTdVmTqHqnQ> > > 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<http://www.google.com/url?q=http%3A%2F%2Fstackoverflow.com%2Fa%2F12051311%2F521799&sa=D&sntz=1&usg=AFQjCNGID2k2hs7XPQ2ASzHoub5Os5Tz9w> > > I wonder if there is a way to operate on the standard JDBC java.sql.SQLXML? > > > > 2013/11/22 Pay Liu <[email protected] <javascript:>> > >> >> 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] <javascript:>. >> 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.
