Copy link to clipboard
Copied
I am in the process of upgrading one of our production CF servers to update 11.8.
The update installs but when I check things out in the cf admin the DSNs are reporting back the following on verification:
SQLNonTransientConnectionException: [Macromedia][Oracle JDBC Driver]No more data available to read.
I have also tried the following updates: 11.9 and 11.10 and get the same errors.
Each time I have had to roll back the update.
Any help in resolving this would be appreciated.
Thank you.
The current server info is:
Server Product | ColdFusion |
Version | 11,0,07,296330 |
Edition | Enterprise |
Operating System | Windows Server 2012 |
OS Version | 6.2 |
Update Level | /C:/ColdFusion11/cfusion/lib/updates/chf11000007.jar |
Adobe Driver Version | 5.1.3 (Build 000094) |
Copy link to clipboard
Copied
Hi,
Can you please check if the Oracle driver is in the directory after applying the update?
Thanks,
Priyank
Copy link to clipboard
Copied
Hi,
Please can you confirm the correct directory location the drivers should be located at?
Thanks
Copy link to clipboard
Copied
Hi,
It should be in \ColdFusion\cfusion\lib or \ColdFusion\cfusion\wwwroot\WEB-INF\lib\
Thanks,
Priyank
Copy link to clipboard
Copied
Hi,
Thats odd , I dont see anything that resembles an Oracle driver file in the current running CF server at the locations you have suggested yet we only have connections to Oracle databases.
Do you know the filename of the standard Oracle driver file that gets shipped with the CF server so I can run a search?
Thanks.
Copy link to clipboard
Copied
Hi,
Can you please verify whether you are using ColdFusion driver or Oracle JDBC driver, as per the error, it seems that you are using Oracle JDBC driver.
Please check of OJDBC jar file.
Thanks,
Priyank
Copy link to clipboard
Copied
Hi,
We are using the one that ships with the Coldfusion server.
jdbc:macromedia:oracle://######.###:1525;SID=dapps;AuthenticationMethod=userIDPassword;se
ndStringParametersAsUnicode=false;querytimeout=0;MaxPooledStatements=100
Does this help?
Thanks.
Copy link to clipboard
Copied
Hi,
Just checked in the CF Admin, the connections we have look like this:
jdbc:macromedia:oracle://######.###:1525;SID=dapps;AuthenticationMethod=userIDPassword;se
ndStringParametersAsUnicode=false;querytimeout=0;MaxPooledStatements=100
So would this be using the macromedia_drivers_jar.jar file?
Thanks
Copy link to clipboard
Copied
Hi,
I tried the same with ColdFusion 11 update 8 and I am unable to reproduce it. I am going to test this on another server and let you know.
Can you please confirm, if it is not happening in update 7?
Thanks,
Priyank