Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle DATE columns lost TIME info through JDBC in 9.2.0.4

406674Oct 21 2003 — edited Jun 8 2004

In Oracle 9.2.0.4.0, it seems Oracle has yet again altered the way it JDBC drivers return Oracle DATE columns. These columns now only refer to date information; the Oracle type TIMESTAMP now is used to contain date and time information. Since my application does not support java.sql.Date, it is reporting that some columns cannot be populated, because the type is unsupported.

Is there anyway that I can get my Oracle DATE columns to return java.sql.Timestamp objects, without losing any precision in my Time value ?

This seems like a bug on Oracle's part--we have a column that stores date and time data (an Oracle DATE column), and the Oracle JDBC driver tells us that the column only stores a date (it reports it as java.sql.Date).

I am using oracle.jdbc.OracleDriver.

Thanks,
Amit

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 6 2004

Added on Oct 21 2003

#java-database-connectivity-jdbc

5 comments

2,498 views