Granted I haven't spent a ton of time looking into this.... but I haven't figured out how to use addValue with a CLOB.
More specifically I want to be able to do the following: UpdateQuery<ProjectTableRecord> u = create.updateQuery(ProjectTable.PROJECT_TABLE); u.addValue(ProjectTable.DESCRIPTION, "I updated the description"); u.addCompareCondition(ProjectTable.ID, id); u.execute(); where DESCRIPTION is a CLOB. Background.... I currently deploy on MySQL but do most development on H2. In MySQL DESCRIPTION is a TEXT column and in H2 DESCRIPTION is a CLOB column. The MySQL mapping generated by jOOQ accepts a String value for the TEXT type. The H2 mapping expects a CLOB value. I thought I RTFM, but perhaps I missed something. :) -J
