Highlighted

connecting from coldfusion10 enterprise edition to oracle 12c database

New Here ,
Feb 10, 2017

Copy link to clipboard

Copied

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..

Views

210

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

connecting from coldfusion10 enterprise edition to oracle 12c database

New Here ,
Feb 10, 2017

Copy link to clipboard

Copied

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..

Views

211

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Feb 10, 2017 0
haxtbh LATEST
Advocate ,
Feb 10, 2017

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Feb 10, 2017 0