Thank you very much for your detailed analysis and sorry for the delay. You're right, this is a bug. It happens every time when a <forcedType/> declaration contains a <types/> matcher. I've registered a fix for this issue: https://github.com/jOOQ/jOOQ/issues/4381
A workaround would be not to match on data types, but on column name expressions instead. This might be viable for the time being, if you follow some naming convention. Thanks again for reporting! Lukas 2015-06-07 12:36 GMT+02:00 <[email protected]>: > Hi, > > there seems to be a bug regarding enum generation (probably only related > to MySQL), when custom forcedType with <type> filter is configured. > > My configuration file: > > <configuration xmlns='http://www.jooq.org/xsd/jooq-codegen-3.6.0.xsd'> > <jdbc> > <driver>com.mysql.jdbc.Driver</driver> > <url>jdbc:mysql://127.0.0.1:3306/myschema</url> > <user>username</user> > <password>password</password> > </jdbc> > <generator> > <database> > <inputSchema>myschema</inputSchema> > <customTypes> > <customType> > <name>LocalDate</name> > <type>java.time.LocalDate</type> > <converter>my.package.LocalDateConverter</converter> > </customType> > <customType> > <name>LocalDateTime</name> > <type>java.time.LocalDateTime</type> > <converter>my.package.LocalDateTimeConverter</converter> > </customType> > </customTypes> > <forcedTypes> > <forcedType> > <name>LocalDate</name> > <types>date</types> > </forcedType> > <forcedType> > <name>LocalDateTime</name> > <types>datetime</types> > </forcedType> > </forcedTypes> > </database> > <generate /> > <target> > <packageName>my.package</packageName> > <directory>src/main/java</directory> > </target> > </generator> > </configuration> > > > There are some enum columns present in the schema completely unrelated to > LocalDate or LocalDateTime types and I would expect them to be generated. > However, with the <forcedType> tags the enums are not generated. > > I was looking at jOOQ sources, and found lines 292-294 at org/jooq/util/ > mysql/ <http://goog_1595004041> > > *MySQLDatabase.java > <https://github.com/jOOQ/jOOQ/blob/246a7261ed2780b2395da3c79fa49c51fa9b3c97/jOOQ-meta/src/main/java/org/jooq/util/mysql/MySQLDatabase.java>*These > lines should filter out enums that match some of the forcedTypes, however, > when getConfiguredForcedType is called like this, regex in <types> tag is > never considered as filter. So when there is <forcedType> without > <expression> filter, the return of getConfiguredForcedType is never null > and all enums are always filtered out. It would be necessary to add > DataTypeDefinition as second argument to make it work. > > Workaround would be not to use <types> filter and always use <expression>. > There is also unaswered stackoverflow question regarding this bug - > http://stackoverflow.com/questions/30260953/how-to-make-jooq-generate-both-enum-types-and-custom-types > > > Could you please evaluate this problem and possibly suggest a fix? > > Regards and thanks. > > -- > 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.
