Hi there, Thanks a lot for your message. jOOQ 3.1 is a very old version, which we're no longer supporting. We've fixed many bugs related to this functionality in the many recent releases going up to jOOQ 3.11. Would you mind trying again with the latest version? If the problem still persists, I will be very happy to assist you.
Thanks, Lukas For the record, and for future readers, this question was also asked on Stack Overflow, here: https://stackoverflow.com/q/52204414/521799 On Thu, Sep 6, 2018 at 10:23 PM <[email protected]> wrote: > > > > 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 [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- 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.
