Highlighted

Coldfusion upgrade issues

New Here ,
Nov 21, 2016

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 ProductColdFusion
Version11,0,07,296330
EditionEnterprise
Operating SystemWindows Server 2012
OS Version6.2
Update Level/C:/ColdFusion11/cfusion/lib/updates/chf11000007.jar
Adobe Driver Version5.1.3 (Build 000094)

Views

285

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

Coldfusion upgrade issues

New Here ,
Nov 21, 2016

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 ProductColdFusion
Version11,0,07,296330
EditionEnterprise
Operating SystemWindows Server 2012
OS Version6.2
Update Level/C:/ColdFusion11/cfusion/lib/updates/chf11000007.jar
Adobe Driver Version5.1.3 (Build 000094)

Views

286

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
Nov 21, 2016 0
Adobe Employee ,
Nov 21, 2016

Copy link to clipboard

Copied

Hi,

Can you please check if the Oracle driver is in the directory after applying the update?

Thanks,

Priyank

Thanks,
Priyank Shrivastava

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...
Nov 21, 2016 0
New Here ,
Nov 21, 2016

Copy link to clipboard

Copied

Hi,

Please can you confirm the correct directory location the drivers should be located at?

Thanks

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...
Nov 21, 2016 0
Adobe Employee ,
Nov 21, 2016

Copy link to clipboard

Copied

Hi,

It should be in \ColdFusion\cfusion\lib or \ColdFusion\cfusion\wwwroot\WEB-INF\lib\

Thanks,

Priyank

Thanks,
Priyank Shrivastava

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...
Nov 21, 2016 0
New Here ,
Nov 21, 2016

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.

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...
Nov 21, 2016 0
Adobe Employee ,
Nov 21, 2016

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

Thanks,
Priyank Shrivastava

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...
Nov 21, 2016 0
New Here ,
Nov 21, 2016

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

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...
Nov 21, 2016 0
New Here ,
Nov 21, 2016

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.

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...
Nov 21, 2016 0
Adobe Employee ,
Nov 23, 2016

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

Thanks,
Priyank Shrivastava

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...
Nov 23, 2016 0