Is it possible to identify exactly the received string in some way?
Il giorno mercoledì 15 giugno 2016 10:17:46 UTC+2, Denis Miorandi ha
scritto:
>
> Hi,
> I'm using a maven plugin to generate jooq classes. Time types are
> mapped on * java.time.*.
> This configuration works right on SQLServer, but on postgres TIMESTAMP
> (with no timezone) is not mapped as expected, so that I've added
> the bold section to achieve this, but it doesn't work.
> Any suggestions?
>
>
>
> <plugin>
> <groupId>org.jooq.pro</groupId>
> <artifactId>jooq-codegen-maven</artifactId>
> <version>${org.jooq.pro.version}</version>
> <executions>
> <execution>
> <id>generate-jooq</id>
> <phase />
> <goals>
> <goal>generate</goal>
> </goals>
> <configuration>
> <jdbc>
> <driver>${spring.datasource.driverClassName}</driver>
> <url>${spring.datasource.url}</url>
> <user>${spring.datasource.username}</user>
> <password>${spring.datasource.password}</password>
> </jdbc>
> <generator>
> <database>
> <name>${jooq-database-name}</name>
> <includes>.*</includes>
> <excludes/>
> <dateAsTimestamp>false</dateAsTimestamp>
> <!-- <inputSchema>PUBLIC</inputSchema> -->
> <inputSchema>${spring.datasource.schema}</inputSchema>
> <customTypes>
> <customType>
> <name>LocalDateTime</name>
> <type>java.time.LocalDateTime</type>
>
> <converter>${company-package-prefix}.jooq.converters.LocalDateTimeConverter</converter>
> </customType>
> <customType>
> <name>LocalDate</name>
> <type>java.time.LocalDate</type>
>
> <converter>${company-package-prefix}.jooq.converters.LocalDateConverter</converter>
> </customType>
> <customType>
> <name>LocalTime</name>
> <type>java.time.LocalTime</type>
>
> <converter>${company-package-prefix}.jooq.converters.LocalTimeConverter</converter>
> </customType>
> <customType>
> <name>XmlSqlXmlBinding</name>
> <type>java.sql.SQLXML</type>
>
> <binding>it.clesius.jooq.bindings.XmlSqlXmlBinding</binding>
> </customType>
> <customType>
> <name>XmlStringBinding</name>
> <type>java.lang.String</type>
>
> <binding>it.clesius.jooq.bindings.XmlStringBinding</binding>
> </customType>
> </customTypes>
> <forcedTypes>
> <forcedType>
> <name>LocalDateTime</name>
>
> <expression>(\w+\.)?(?!UDT_PREFIX|PROC_PREFIX)\w+(\.\w+)?</expression>
> <types>DATETIME</types>
> </forcedType>
> <forcedType>
> <name>LocalTime</name>
>
> <expression>(\w+\.)?(?!UDT_PREFIX|PROC_PREFIX)\w+(\.\w+)?</expression>
> <types>TIME</types>
> </forcedType>
> <forcedType>
> <name>LocalDate</name>
>
> <expression>(\w+\.)?(?!UDT_PREFIX|PROC_PREFIX)\w+(\.\w+)?</expression>
> <types>DATE</types>
> </forcedType>*
> <forcedType>
> <name>LocalDateTime</name>
>
> <expression>(\w+\.)?(?!UDT_PREFIX|PROC_PREFIX)\w+(\.\w+)?</expression>
> <types>TIMESTAMP</types>
> </forcedType>*
> <!--
> <forcedType> -->
> <!--
> <name>OffsetTime</name> -->
> <!--
> <expression>(\w+\.)?(?!UDT_PREFIX|PROC_PREFIX)\w+(\.\w+)?</expression> -->
> <!--
> <types>TIME_WITH_TIMEZONE</types> -->
> <!--
> </forcedType> -->
> <!--
> <forcedType> -->
> <!--
> <name>OffsetDateTime</name> -->
> <!--
> <expression>(\w+\.)?(?!UDT_PREFIX|PROC_PREFIX)\w+(\.\w+)?</expression> -->
> <!--
> <types>TIMESTAMP_WITH_TIMEZONE</types> -->
> <!--
> </forcedType> -->
> <forcedType>
> <name>XmlStringBinding</name>
>
> <expression>(\w+\.)?(?!UDT_PREFIX|PROC_PREFIX)\w+(\.\w+)?</expression>
> <types>XML</types>
> </forcedType>
> </forcedTypes>
> </database>
>
> <generate>
> <deprecated>false</deprecated>
> <instanceFields>true</instanceFields>
> <pojos>true</pojos>
> <validationAnnotations>true</validationAnnotations>
> <fluentSetters>true</fluentSetters>
> </generate>
> <target>
> <packageName>${jooq-packageName}</packageName>
> <!--
> <directory>target/generated-sources/jooq-sqlserver</directory> -->
> <directory>src/main/generated</directory>
> </target>
> </generator>
> </configuration>
> </execution>
> </executions>
> <dependencies>
> <!-- db here -->
> <!-- <dependency> -->
> <!-- <groupId>com.h2database</groupId> -->
> <!-- <artifactId>h2</artifactId> -->
> <!-- <version>${h2.version}</version> -->
> <!-- </dependency> -->
> </dependencies></plugin>
>
>
--
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.
