Oracle 10g Lite dates and Coldfusion 8/9

If you are running Oracle 10g databases and Coldfusion Standard 8 or 9 you may experience a problem with ColdFusion returning dates with a 00:00 time value.   This is a driver issue.  The driver that comes with the Oracle 10g database is for JVM 1.4 and 1.5.  ColdFusion 8 actually ships with JVM 1.6.  What you need to do it download and install the newer driver for the Oracle 11g database. I don't believe there is a lot of difference but the main one is that it is for the JVM 1.6 platform.  Installing the updated driver will correct the date/time issues.

If you are using ColdFusion Enterprise and you are using the packaged Oracle drivers you don't need to worry about this as they are correct drivers.

0 comments - Posted by Steve Onnis at 11:10 AM - Categories: Coldfusion | Coldfusion Server | Oracle