Shulou(Shulou.com)06/01 Report--

About the correspondence between Oracle JDBC driver version, JDK version and database version

Description:

1. How to view the Oracle JDBC driver version (the Oracle JDBC driver is provided with the Oracle database server) (user: Oracle ")

$cd $ORACLE_HOME/jdbc/lib

Ojdbc5.jar

Ojdbc6.jar

2. Check the JDK version: $java-version (user: Oracle)

[oracle@4313 ~] $java-version

Java version "1.5.051"

Java (TM) 2 Runtime Environment, Standard Edition (build 1.5.0_51-b10)

Java HotSpot (TM) 64-Bit Server VM (build 1.5.0_51-b10, mixed mode)

The detailed correspondence is as follows:

MOS:

Doc ID 401934.1

Doc ID 2111876.1

Which JDBC driver version is used with which JDK version?

From JDBC FAQ on the Oracle Technology Network (OTN), the OCI or Thin JDBC driver version supports the JDK version of the following Javasoft:

JDBC version JDK version JDBC file name

19.3

8.x

9.x

10.x

11.x

Ojdbc8.jar

Ojdbc8.jar

Ojdbc10.jar

Ojdbc10.jar

18.3

8.x

9.x

10.x

11.x

Ojdbc8.jar

12.2.0

8.x

Ojdbc8.jar

12.1.08.x

7.x

6.xojdbc7.jar

Ojdbc7.jar

Ojdbc6.jar11.2.0

8.x * *

7.x * *

6.x

5.x

Ojdbc6.jar

Ojdbc6.jar

Ojdbc6.jar

Ojdbc5.jar11.1.06.x

5.xojdbc6.jar

Ojdbc5.jar10.2.0

1.2.x

1.3.x

1.4.x

5.x

Classes12.jar

Classes12.jar

Ojdbc14.jar

Ojdbc14.jar

10.1.0

1.2.x

1.3.x

1.4.x

Classes12.jar

Classes12.jar

Ojdbc14.jar

9.2.0

1.1.x

1.2.x

1.3.x

1.4.x

Classes111.zip *

Classes12.zip *

Classes12.zip *

Ojdbc14.jar

The following table lists which JDBC drivers can access which Oracle databases:

JDBC driver

Oracle database

19.3.0

19.3

18.3

12.2.0

12.1.0

11.2.0

18.3.0

19.3

18.3

12.2.0

12.1.0

11.2.0

12.2.0

19.3

18.3

12.2.0

12.1.0

11.2.0

12.1.0

19.3

18.3

12.2.0

12.1.0

11.2.0

11.1.0

11.2.0

19.3

18.3

12.2.0

12.1.0

11.2.0

11.1.0

10.2.0

10.1.0

9.2.0

11.1.0

12.1.0

11.2.0

11.1.0

10.2.0

10.1.0

9.2.0

10.2.0

12.1.0

11.2.0

11.1.0

10.2.0

10.1.0

9.2.0

10.1

11.2.0

11.1.0

10.2.0

10.1.0

9.2.0

9.2.0

11.2.0

11.1.0

10.2.0

10.1.0

9.2.0

1. Application side JDBC connection error: ORA-28040, which is caused by the low JDBC driver version of the Oracle 12c database connected by the application side.

Solution:

1) upgrade the JDBC driver version; upgrade the JDBC driver version to the corresponding JDBC driver version that connects to the database

2) in cd $ORACLE_HOME/network/admin/sqlnet.ora, modify the database authentication protocol:

Before the database is modified:

In sqlnet.ora:

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10 (Certification level Adjustment)

SQLNET.ALLOWED_LOGON_VERSION_SERVER=10

After the database is modified:

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.