Hello Leonardo, It is an open feature-request to allow for mapping Oracle's DATE columns to java.sql.Timestamp: https://sourceforge.net/apps/trac/jooq/ticket/976
This mapping will be implemented for jOOQ 2.0.2, which is due for next week. In the mean time, as a workaround, you can either use Oracle's TIMESTAMP data type, or manually patch generated source code to reference org.jooq.impl.SQLDataType.TIMESTAMP. I hope this helps Cheers Lukas 2012/1/5 Leonardo Diaz <[email protected]>: > Good day, I have a stored procedure, and I'm calling it by using the > auto-generated code from jooq. > > The problem is that one of the out parameters is, in oracle, Date > type, jooq parse it as sql.Date class type, but the minutes and > seconds are lost, I only get year, month and day. I tried forcing > from the oracle sql query the date format as needed but it seems that > the java part ignores the hours and minutes. > > I'm using Oracle 10g, any advice?? is there any extra configuration > I'm missing?? > > Thanks a lot.
