Thanks Lukas, Will run this again. Thanks for the great work! On Wednesday, December 10, 2014 6:57:59 AM UTC-5, Lukas Eder wrote: > > Hello, > > I've looked into your case. The problem here is the fact that MySQL > reports data types in lower case, while the jOOQ code generator applies > simple Java regex matching with the <types/> configuration. The following > config will work for me: > > <forcedType> > <name>BOOLEAN</name> > <expression>.*</expression> > <types>tinyint</types> > </forcedType> > <forcedType> > <name>BIGINT</name> > <expression>.*</expression> > <types>int</types> > </forcedType> > > > Essentially, you can find the column / type combinations as reported by > MySQL like this: > > select column_name, data_type > from information_schema.columns > where table_name = 'sample' > order by ordinal_position > > > I think we should improve the manual and make another reference about > using case-insensitive regular expressions, just to stay on the safe side: > > <forcedType> > <name>BIGINT</name> > <expression>.*</expression> > <types>(?i:int)</types> > </forcedType> > > > https://github.com/jOOQ/jOOQ/issues/3859 > > Hope this helps, > Lukas > > 2014-12-08 15:50 GMT+01:00 <[email protected] <javascript:>>: > >> Here is a sample >> CREATE TABLE `sample` ( >> `id` int(11) NOT NULL AUTO_INCREMENT, >> `soft_deleted` tinyint(1) NOT NULL, >> PRIMARY KEY (`id`) >> ) >> >> I get that the number in parenthesis are formatting details, but these >> are existing tables. int to Long and tinyint to boolean. Thanks very much. >> >> On Monday, December 8, 2014 3:13:59 AM UTC-5, Lukas Eder wrote: >>> >>> Hi. >>> >>> I suspect you're using MySQL given that you're specifying formatting >>> lengths for fixed-size integers. Do note that there is no such thing as an >>> INT(11) type in SQL, even in MySQL. 11 only means the width of the >>> formatting, not the actual number of decimal digits. The same holds true >>> for TINYINT(1), which doesn't mean numbers with only 1 digit. It means that >>> by default, only one digit is displayed. >>> >>> If fixing the schema accordingly is not an option, I can help with the >>> configuration, if you provide me with the DDL of the tables that you'd like >>> to convert, but that don't really work... >>> >>> Best Regards, >>> Lukas >>> >>> 2014-12-08 6:11 GMT+01:00 <[email protected]>: >>> >>>> HI, >>>> >>>> I am trying to get forcedTYpes defined in my pom.xml to generate code >>>> is our preferred type (Env mysql, jooq 3.5.0) >>>> >>>> columsn marked an INT , INT(11) get generated with type Integer, but we >>>> would like them as Llong the generated java classes. Also need tinyint(1) >>>> to mapped to Boolean. >>>> >>>> I have tried some variation of below declarations, but still not >>>> getting the preferred types. >>>> <forcedTypes> >>>> <forcedType> >>>> <name>TINYINT(1)</name> >>>> <expression>.*</expression> >>>> <types>BOOLEAN</types> >>>> </forcedType> >>>> <forcedType> >>>> <name>BIGINT</name> >>>> <expression>.*</expression> >>>> <types>INT</types> >>>> </forcedType> >>>> </forcedTypes> >>>> >>>> -- >>>> 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] <javascript:>. >> 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.
