Hi David,

> "JdbcUtils class: Uses the getObject(index) method, but includes
> additional "hacks" to get around Oracle 10g returning a non-standard
> object for its TIMESTAMP datatype and a java.sql.Date for DATE columns
> leaving out the time portion: These columns will explicitly be
> extracted as standard java.sql.Timestamp object."

I understand. jOOQ only uses ResultSet.getObject(index) when the data
type is unknown (or for REF CURSOR, UDT, and master data types). So
I'm guessing that somehow, you have declared your table column with a
type that jOOQ did not recognise.

If this is a jOOQ issue, I will need some more information about how
to reproduce this:
- How is your table defined (as in: what's the relevant CREAT TABLE
statement to produce that column)?
- How did you query that table?

> Guess that's why the returned type is a non-jdbc-standard
> Oracle.sql.TIMESTAMP, Oracle 10g is still out there popular, so I
> think it's good to know.

I agree with that!

Cheers
Lukas

Reply via email to