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

Regards,
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.

Reply via email to