We're in the process of upgrading from ColdFusion 8 to ColdFusion 9, and we're starting by testing out the newest thin Oracle JDBC drivers (both driver versions 10 and 11) against ColdFusion 8. We've been using the same Oracle thin JDBC driver since 2004 (version 9.2), so we figured it's time to upgrade. We're currently using Oracle database 10.1.0.4, if that has any bearing.
Our problem is, any SQL code with TO_DATE( ) which omits a format and uses our instance-level settings for NLS_DATE_FORMAT ('MM/DD/RR') is failing with the newer JDBC drivers. So anything like the following is now failing:
... where date_field > to_date('03/04/2010')...
Somewhere, the newer drivers must be running a
ALTER SESSION set NLS_DATE_FORMAT = 'DD-MON-RR'
We know how to fix the ColdFusion code, but I'd rather find where the ALTER SESSION happens, change that AND then simultaneiously start changing the code. Worst case scenario we'll setup a LOGON trigger, but I don't want to go there yet.
Thanks for the help.
--=Chuck
Edited by: chuckers on Mar 4, 2010 12:44 PM
Slightly rewritten, I had originally misunderstood some of the details.