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?
