I'm using jooq 3.8.6 and I have one schema I'm importing from a Postgres
DB, and I am forcing use of the java.time with the following <database/>
block:
<forcedTypes>
<forcedType>
<name>LOCALDATE</name>
<types>^DATE$</types>
</forcedType>
<forcedType>
<name>LOCALTIME</name>
<types>^TIME$</types>
</forcedType>
<forcedType>
<name>LOCALDATETIME</name>
<types>^TIMESTAMP$</types>
</forcedType>
</forcedTypes>
This works fine so far. However, I am also trying to import another schema
from a MS Sql Server 2012 instance. I downloaded and installed the jooq
trial in my maven tree and I'm trying to use the same basic mappings with
the T-SQL data types:
<forcedTypes>
<forcedType>
<name>LOCALDATE</name>
<types>^DATE$</types>
</forcedType>
<forcedType>
<name>LOCALTIME</name>
<types>^TIME$</types>
</forcedType>
<forcedType>
<name>LOCALDATETIME</name>
<types>^(SMALL)?DATETIME2?$</types>
</forcedType>
<forcedType>
<name>OFFSETDATETIME</name>
<types>^DATETIMEOFFSET$</types>
</forcedType>
</forcedTypes>
but this gives the following error:
[INFO] Forcing type : mydb.dbo.mytable.ADateTimeField with type
datetime into LOCALDATETIME
[WARNING] Bad configuration for <forcedType/> LOCALDATETIME. No matching
<customType/> found, and no matching SQLDataType found: <?xml version="1.0"
encoding="UTF-8" standalone="yes"?>
<forcedType xmlns:ns2="http://www.jooq.org/xsd/jooq-codegen-3.8.0.xsd";>
<ns2:name>LOCALDATETIME</ns2:name>
<ns2:types>^(SMALL)?DATETIME2?$</ns2:types>
</forcedType>
I checked the SQLDataType class found in the trial package, and it does
include LOCALDATETIME and family same as the OSS version. That warning
appears for all four of the types I'm trying to force.
What could I be doing wrong here?
-Daniel
--
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.
