While upgrading Oracle database to 12C, standalone applications using Oracle driver for database connectivity leveraging OJDBC14.jar fails with exception java.sql.SQLException: ORA-28040: No matching authentication protocol.
Oracle documents mentions following,
- Since Oracle Database 11g Release 1, support for a version of JDK earlier than version 5.0 has been removed. Also, the ojdbc14.jar, ojdbc5.jar and classes12.jar files are no longer shipped. Instead, you can use the ojdbc6.jar and ojdbc7.jar files, which are shipped with Oracle Database 12c.
- If you are using JSE 6 and later, then there is no need to explicitly load the JDBC driver. This means that the Java run-time loads the driver when needed and you need not include Class.forName("oracle.jdbc.OracleDriver") or new oracle.jdbc.OracleDriver() in your code. But if you are using J2SE 5.0, then you need to load the JDBC driver explicitly.
Which requires to upgrade to OJDBC6.jar or OJDBC7.jar.
Is SQLNET.ALLOWED_LOGON_VERSION_CLIENT parameter for the SQLNet.ora file can be used to avoid OJDBC jar upgrade at java applications side?