2014-03-25 16:59 GMT+01:00 Lukas Eder <[email protected]>: > Hi Gérald > > 2014-03-23 14:28 GMT+01:00 Gérald Quintana <[email protected]>: > > I found the solution by myself, the <expression> is case sensitive and is >> lower case in MySQL, >> <forcedTypes> >> <forcedType> >> <name>java.util.Date</name> >> <expression>.*last_update</expression> >> <types>timestamp|date</types> >> </forcedType> >> </forcedTypes> >> > > Glad it worked out for you. Yes, <expression> is case-sensitive as it is a > Java regular expression. To create case-insensitive regular expressions, use > > (?i:...) > > > By default, everything in jOOQ is case-sensitive because that's the only > sane way to handle SQL case-sensitivity. > > What kind of values does the <types> match? I tried "java\.sql\.Timestamp" >> before finding out it was "timestamp". >> > > The SQL data type (not the Java data type) as reported by your database. > In the case of MySQL, this is what is reported by > INFORMATION_SCHEMA.COLUMNS.DATA_TYPE >
I realise that this part of the manual merits some more detailed documentation. I have registered an issue for this #3155: https://github.com/jOOQ/jOOQ/issues/3155 Cheers Lukas -- 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.
