About Oracle JDBC driver version, JDK version, database version pair
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
