strange problem using DATE fields from coldfusion/MX (jdbc)

existing coldfusion 5 code, using ODBC connections, can SELECT and UPDATE oracle (9.2) DATE fields, without any problems.

when checking same functionality with the coldFusion MX, which uses jdbc, we are using the 10g thin client (ojdbc14.jar), you cannot SELECT or UPDATE the time component of the field. everything's is read as on midnight.

any clue ? Received on Tue Jul 18 2006 - 18:06:16 CDT