JDBC Thin Client-Side Driver Installation

JDBC for Oracle - Herong's Tutorial Examples

∟JDBC Thin Client-Side Driver Installation

This section describes how to download and install Oracle JDBC thin client-side driver.

Among 4 different Oracle JDBC drivers offered by Oracle, JDBC Thin client-side driver is the simplest one to install and to use. Here is what I did to download and install the latest version on my local computer:

Go to Oracle JDBC and UCP Downloads Page at https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html.
Click on the link "Oracle Database 21c (21.4) drivers" in the "Oracle Database 21c and 19c JDBC driver" section. I see the "Oracle Database 21c (21.4) JDBC Driver & UCP Downloads" page.
Click on the link "ojdbc11.jar" next the "Certified with JDK11, JDK12, JDK13, JDK14, and JDK15; ..." line. It should work for JDK 17 also.
Save the download file, ojdbc11.jar, to current working directory.

Installation of JDBC driver for Oracle server is done now.

If you are using older versions of JDK and/or older versions of Oracle servers, you need to find and download the correct version of JDBC Thin client-side driver JAR file, ojdbcXX.jar, according to the following table:

JAR Name         JDK Versions   Oracle versions
--------         ------------   ---------------
ojdbc11.jar      JDK 11+        Oracle 21c+
ojdbc10.jar      JDK 10+        Oracle 19c+
ojdbc8.jar       JDK 8+         Oracle 12c+
ojdbc7.jar       JDK 7+         Oracle 12c+
ojdbc6.jar       JDK 6+         Oracle 11g+
ojdbc5.jar       JDK 5+         Oracle 11g+
   
ojdbc14.jar      JDK 1.4+       Oracle 9i+
classes12.jar    JDK 1.2+       Oracle 8i+
classes12.jar    JDK 1.2+       Oracle 8i+
classes111.jar   JDK 1.1+       Oracle 8i+