I think I found a bug in jOOQ generator: previously (3.8.1) it managed to
create classes for function with same names but different arguments/return,
e.g.: myfunction() and myfunction(INTEGER).
It used to generate two classes (Myfunction1.java and Myfunction2.java and
corresponding records) and everything was fine.
I wanted to upgrade to 3.10.2, but the generator doesn't work anymore in
such case. It creates one class (Myfunction.java) with duplicated fields. I
tried with 3.9.1, I get the same result.
Before I realised it is related to functions with same name, I created a
post on StackOverflow with (slightly) more details:
Thanks for your message. The easiest way forward in these cases is to use
the code generator that is built into jOOQ. It will generate those
VARCHAR.asEnumDataType() mappings for you, so you will never need to
If you cannot or do not want to use the code generator, then you will need
to do the exact same thing as the code generator would have done, manually.
Your usage of the API is correct, you somehow have to tell the jOOQ runtime
API that what appears to be a VARCHAR type is really an enum type, in case
of which jOOQ will be able to generate the necessary cast for you.
You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page.
To unsubscribe from this group and stop receiving emails from it send an email to [hidden email].