connecting from coldfusion10 enterprise edition to oracle 12c database

Report · Feb 10, 2017

i am facing issues when upgrading coldfusion 6 to coldfusion 10 (Enterprise) using oracle 12c database.
in CF10 Administrator data & sources tab selecting others drop down here providing jdbc:macromedia.oracle:<servername>:port:SID;
Driver class name : macromedia:jdbc:MacromediaDriver
having jar files are OJDBC7 & OJDBC 14 in my Web sphere CFFUSION/LIB folder .

When calling one of the Stored Procedure in my application procedure using 3 reference cursors
Getting error message like : Error executing database query : Jdbc [macromedia ][oracle jbbc drivers][oracle][ora-20001].error encountered -2074-ORA-06512 : cannot set nls in Distributed transcations..

There is other senarion which i can able to get the data from other stored procedure if the procedure using 1 or 2 reference cursors..

using cfprocresult tag for results in stored proc..

Please let me know how do I achieve result by using 3 reference cursors ..

Thanks in advance..

Report · Feb 10, 2017

There are a few threads about CF10 and Oracle 12c. The bottom line is that its not supported so things probably will not work - Has anyone started testing CF 10 with Oracle 12c yet?

You could start by trying the oracle class name - oracle.jdbc.OracleDriver