Oracle 10g JDBC Thin Drivers and Time

[sdittbrenner]

We have the same problem the newest version of Coldfusion with the newest
oracle jdbc driver displays only the date, not the time. The same jdbc driver
used in a little pure java program displays both, date and time.
What have i done?
In the java program i have create a OracleResultSet and have used the methodes
getTimestamp() and getDATE() (don't confuse with getDate() from Java). Both
object types will return date and time information. The DATE object from Oracle
supports the methodes dateValue() for extracting the date, timeValue() for the
time, timestampValue() for a complett timestamp and stringValue() which returns
a string representation of the DATE object. The definition of the DATE object
shows that it is a representation of the Oracle data type "date" with all
needed conversions:
"The DATE class provides conversions between the Oracle Date (ldx_t) data type
and Java classes java.sql.Date, java.sql.Time, java.sql.Timestamp"
I also used a Java ResultSet with the method getTimestamp() to display the
values of Oracle date columns. It works fine! Using the methods getMetaData()
and getColumnTypeName() has displayed "DATE" as type for the column.
So i guess that ColdFusion gets the metadata "DATE" for the column and confuse
it with the Java datatype "Date" which will results in the effect above: the
time part will be ignored.

[sdupre]

What clob performance issues are you talking about? Are these against the build-in Oracle drivers?

Let's solve the first problem.

Stephen Dupre
Macaromedia QA