Re: What is the right way to getValueAsTimestamp

[Lukas Eder]

Hi David,

I cannot reproduce this behaviour. Where do you get that
oracle.sql.TIMESTAMP from? I'm not aware of ojdbc returning this type
when calling ResultSet.getTimestamp(). Can you post the DDL defining
the involved tables, the query you're running, and the ojdbc version
you're using?

Cheers
Lukas

2012/2/19 david sheng <sdwc...@gmail.com>:
> env:
> DB=Oracle
> jooq.version=2.0.4
>
> story:
> when program hit on jooq api method:
>       record.getValueAsTimestamp((String)fieldname)
> //this column in db is defined as: TIMESTAMP(6)
>
> exception thrown:
> org.jooq.exception.DataTypeException: Cannot convert from
> oracle.sql.TIMESTAMP@19fc25 (class oracle.sql.TIMESTAMP) to class
> java.sql.Timestamp
>        at org.jooq.tools.Convert.fail(Convert.java:363)
>        at org.jooq.tools.Convert.convert(Convert.java:333)
>        at org.jooq.impl.AbstractStore.getValueAsTimestamp(AbstractStore.java:
> 240)
>
>
> So I wonder what is the right way to use getValueAsTimestamp() method?