1 Correct answer
Hi All,
We have a fix available to address this issue. Please contact the support team at cf.install@adobe.com for the fix.
Thanks,
Vikram
49
Replies
Hi,
Its for both, I put it in the bug description.
The form did not allow me to put for both versions so I just selected 2023.
@EvanSinceCF31Just out of the curiosity, what is the error you were getting when you did the following?
...
I also found that a custom Java class that connects to Oracle called from CF using the CF data source started failing with the change to ojdbc11.jar, apparently because the auto-commit setting is different than the DataDirect drivers. I was able to update the Java class to explicitly disable auto-commit to resolve that issue. Alternatively I could have added -Doracle.jdbc.autoCommitSpecCompliant=false to my CF JVM arguments.
...
By @EvanSinceCF31
Does anyone know how do we find information (version etc) about the built-in "Oracle" driver Adobe Coldfusion is using?
By @dejank52055655
That is difficult to find out because the built-in drivers that ColdFusion uses are not individually exposed as Java classes. They are collectively bundled together as the class macromedia.jdbc.MacromediaDriver.
You can see that by running this code:
<cfscript>
MacromediaDriverClass="macromedia.jdbc.MacromediaDriver";
MacromediaDriverObject=createobject("java", MacromediaDriverClass);
writeoutput("<p>Macromedia driver class: " & MacromediaDriverClass & "<br>");
writedump(var=MacromediaDriverObject.driverNamesMapping, label="Driver Names in Macromedia Driver");
</cfscript>
On the other hand, if you happen to know the driver class (for example, I happen to know that my application uses MySQL inported through a Jar file), then you can determine the driver's major and minor version as follows:
<cfscript>
MySQLDriverClass="com.mysql.cj.jdbc.Driver";
MySQLdriverObject=createobject("java", mySQLDriverClass);
writeoutput("<p>MySQL driver class: " & mySQLDriverClass & "<br>");
writeoutput("Driver major version: " & MySQLdriverObject.getMajorVersion() & "<br>");
writeoutput("Driver minor version: " & MySQLdriverObject.getMinorVersion() & "<br>");
</cfscript>
To see all the database drivers available in ColdFusion, run the following code:
<!--- Login into Coldfusion Administrator. --->
<cfset createObject("component","cfide.adminapi.administrator").login("your_CFAdmin_password")>
<!--- Instantiate the data source object. --->
<cfset datasourceObject = createObject("component","cfide.adminapi.datasource")>
<!--- Get a structure containing all the database drivers and dump it--->
<cfset databaseDrivers = datasourceObject.getDriverDetails()>
<cfdump var="#databaseDrivers#">
AdChoices