jdbc error while connecting oracle 12c in Coldfusionmx7

New Here ,
May 04, 2016 May 04, 2016

Copy link to clipboard

Copied

We have a set of Applications in Coldfusion MX7 with Oracle 11g Database.

Connected Datasources in Coldfusion using JDBC thin Driver. The coldfusion server has ojdbc14.jar in c:\coldfusionmx7\lib

The Oracle version has now been upgrade to 12c.

The Application throws "ORA-28040: No matching authentication protocol"

We googled and found that the jdbc driver used is not compatible and they suggested

1. change the ojbc14.jar to ojdbc6.jar in c:\coldfusionmx7\lib, restart Coldfusion server and start mapping the Datasources.

2. Set SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 in the oracle/network/admin/sqlnet.ora file.

Please give us a clear suggestion

1. Whether downloading ojdbc6.jar from Oracle website and placing it in c:\coldfusionmx7\lib instead of ojdbc14.jar

will work properly- Is it compatible with MX7?

2. Adding the server version "SQLNET.ALLOWED_LOGON_VERSION_SERVER=8" in sqlnet.ora file will do or

do we have to specify SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8 also. If so, do we have to restart the Database

server to make it effective?

Thanks

Views

2.0K

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
community guidelines
Advocate ,
May 05, 2016 May 05, 2016

Copy link to clipboard

Copied

LATEST

I doubt you will get this working as you fully intend. 12c support is only available on CF11. Some older version have had luck getting this working but we are talking CF9/10. MX7 may have further complications.

Generally I think the only way for the older version is to add the SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8 to the sqlnet.ora. I think the people using this trick are using a version of CF that supports 11g though. MX7 only supports up to 10g.

You will have to try ojdbc6.jar or ojdbc7.jar to see if it makes any difference when trying it with CF. ojdbc7.jar is the 12c JDBC driver.

Any changes you make will require service restarts.

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
community guidelines