You need to have an Oracle PKI driver to get the Oracle driver to work (attached)
You need to have ojdbc*.jar and the attached pki-provider-1.4.2_04.jar the same folder (typically cfusion\lib)
Note that you also have to turn off autogenerated keys:
In FusionReactor we stick to the JDBC standard for autogenerated keys but ColdFusion has a special for handling turning off autogeneratedkeys automatically behind the scenes when you use the Oracle thin driver. There should be a checkbox on the JDBC datasource Advanced settings in the ColdFusion Administrator -> Disable Autogenerated Keys
You then need to use a special -D option to turn off the AutoGenerated keys for a datasource. No spaces or brackets are allowed e.g:
-Dcoldfusion.noautogenkeydsns=ora8,ora8_2,oraadmin,oraadmin_2
Regards,
|
This e-mail and any files transmitted with it are confidential and may be protected by legal privilege. If you are not the intended recipient, please notify the sender and delete the e-mail from your system. This e-mail has been scanned for malicious content but the internet is inherently insecure and Intergral GmbH cannot accept any liability for the integrity of this message or its attachments.
I have spoken to our engineers and believe you may be running into a bug within FusionReactor 6.
This bug occurs when FusionReactor attempts to run the query plan on oracle DB connections. If you have the query plan enabled can you try disabling this feature and see if the issue no longer occurs.
In an upcoming major release of FusionReactor this issue has been fixed, however at this time I cannot confirm when this version will be released.
It is also worth mentioning that since the google groups post was created, we have removed the need for the PKI driver to be installed.
You may also want to ensure that you are actually using the ojdbc6.jar, ColdFusion 10 by default comes with the Macromedia oracle driver out of the box. If this driver is being used we recommend you change this to make sure your .jar file is being used.
In the past we have seen that using prepared statements within FusionReactor can cause issues, but we have performed a code review and this should not be the case.
If after trying the above suggestions you are still experiencing issues, could you provide me with an example query that is failing? I can then attempt to reproduce and work around the issue.
Michael Flewitt
FusionReactor Support Engineer
From: fusion...@googlegroups.com [mailto:fusion...@googlegroups.com] On Behalf Of michael...@intergral.com
Sent: Tuesday, May 30, 2017 03:46 AM
To: FusionReactor <fusion...@googlegroups.com>
Subject: Re: [fusionreactor] Oracle JDBC via FR is running in an not existing error
Hi Charlie,
Just so you are aware, FusionReactor 6 no longer requires the PKI driver so this should no longer be an issue.
The fact that this post is from 2015 means unfortunately some of the information provided is now outdated for the latest version.
<snip>
On Monday, May 29, 2017 at 5:56:00 PM UTC+2, charlie arehart wrote:
<snip>