Hi, Thanks for reporting.
I think the problem here is really in the code generator. I'm not sure why Firebird reports 8 as RDB$FIELDS.RDB$FIELD_LENGTH, but I guess the best thing would just be to ignore field lengths for BLOB and CLOB types at code generation time. I have registered #3342 for this, which will be fixed for jOOQ 3.4.0 to be released today https://github.com/jOOQ/jOOQ/issues/3342 Note that while casting bind values is not necessary in VALUES() clauses of INSERT statements, it is most often necessary in general, for databases like Firebird. This is documented here: http://blog.jooq.org/2011/08/31/rdbms-bind-variable-casting-madness/ Cheers, Lukas 2014-06-20 9:42 GMT+02:00 <[email protected]>: > Hello, > > i think there is a problem if a field is kind of blob in firebird. > > exemple : > > tidesc => BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER SET NONE COLLATE NONE > > JOOQ generate this insert : > > insert into "TIERS" ("TIDESC") values (cast(? as blob sub_type text(8))) > > the problem is that blob sub type text(8) is not valid, it should be "blob > sub_type 1" > > do you think i can get around this with the jooq actual version ? disable > the cast ? change the cast ? > > thanks in advance > > -- > 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.
