Jooq 3.1.0 and Oracle date column

[sergkunz3]

 

 Hello,

I’m using Jooq v3.1.0 and have a problem with Oracle Date column. An Oracle 
procedure called by Jooq  returns only date without time (e.g.: 
“31.08.2018”. I expected “31.08.2018 18:44:05”)

 

I tried the following workaround

<database>

  <!-- Use this flag to force DATE columns to be of type TIMESTAMP -->

  <dateAsTimestamp>true</dateAsTimestamp>

 

  <!-- Define a custom binding for such DATE as TIMESTAMP columns -->

  <forcedTypes>

    <forcedType>

      <userType>java.sql.Timestamp</userType>

      <binding>org.jooq.impl.DateAsTimestampBinding</binding>

      <types>DATE</types>

    </forcedType>

  </forcedTypes>

</database>

 

But it did not work throwing the following error:

org.jooq:jooq-codegen-maven:3.1.0:generate for parameter userType: Cannot 
find 'userType' in class org.jooq.util.jaxb.ForcedType


Separate <dateAsTimestamp>true</dateAsTimestamp> doesn’t work either.


Thanks.

 

-- 
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 jooq-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.