Thanks a lot, right now I'll use your fix that works as expected,
while I wait fot the 2.0.2.
For the reference:The method of the class that calls the procedure
ended like this:
public static final org.jooq.Parameter<java.sql.Timestamp>
MY_ORACLE_DATE_FIELD = createParameter(" MY_ORACLE_DATE_FIELD",
org.jooq.impl.SQLDataType.TIMESTAMP);On 5 ene, 12:37, Lukas Eder <[email protected]> wrote: > 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.
