How To select Oracle Driver Version

This post describes how to use diffrent JDBC drivers with diffrent JDK versions.
whenever we upgrdate our database or JDK we are facing Exceptions like "DriverManager.getConnection gives the Error: "No suitable driver".

Check this link for more information how to select oracle driver version and other database version.

Which JDBC drivers support which versions of Javasoft's JDK?

Below table shows how to use jdk and JDBC drivers.

Driver Compatibility Matrix

JDBC drivers Version	Driver Type	JDK Version
Oracle pre-8i	OCI THIN Drivers	JDK 1.0.x and JDK 1.1.x
Oracle 8.1.5	OCI and THIN Drivers	JDK 1.0.x and JDK 1.1.x
Oracle 8.1.6 SDK	THIN Driver	JDK 1.1.x and JDK 1.2.x (aka Java2)
8.1.6 SDK	OCI Driver	JDK 1.1.x
8.1.6	OCI and THIN Driver	JDK 1.1.x and JDK 1.2.x
8.1.7	OCI and THIN Driver	JDK 1.1.x and JDK 1.2.x
9.0.1	OCI and THIN Driver	JDK 1.1.x, JDK 1.2.x and JDK 1.3.x
9.0.2	OCI and THIN Driver	JDK 1.1.x, JDK 1.2.x, JDK 1.3.x, and JDK 1.4.x
10.1.0	OCI and THIN Driver	JDK 1.1.x, JDK 1.2.x, JDK 1.3.x, and JDK 1.4.x
10.2.0	OCI and THIN Driver	JDK 1.2.x, JDK 1.3.x, JDK 1.4.x, and JDK 5.0.x

What are the jar files and supported JDK Installation.

Supported JDK Installation for Oracle Drivers.

Supported Jar File	Java Version	Remarks
ojdbc5.jar	JDK1.5
ojdbc5_g.jar	JDK1.5	compiled with option -g
ojdbc5dms.jar	JDK1.5	includes code to support Oracle Dynamic Monitoring Service
ojdbc5dms_g.jar	JDK1.5	includes code to support Oracle Dynamic Monitoring Service
ojdbc6.jar	JDK1.6	support basic functionality for the Thin and OCI drivers
ojdbc6_g.jar	JDK1.6
ojdbc6dms.jar	JDK1.6	Oracle Dynamic Monitoring Service (DMS)
ojdbc6dms_g.jar	JDK1.6	full JDBC logging support

In future whenever you upgrade Database version you have to conside appropriate JDK version.

References :

1. Oracle Driver Version @ http://www.oracle.com/technetwork/java/hotspotfaq-138619.html
2. Feature Matrix for Oracle Server JDBC drivers @ https://www.inetsoftware.de/products/jdbc-driver/oracle/features