Java Oracle Jdbc Driver

by

Download

Release Notes

  1. (4,036,257 bytes)
  2. (SHA1 Checksum: 60f439fd01536508df32658d0a416c49ac6f07fb)
  3. Certified with JDK 8; It contains the JDBC driver classes except classes for NLS support in Oracle Object and Collection types.
  1. (1,099,788 bytes)
  2. (SHA1 Checksum:860bd44a5a593385464a49590169bee81c4482a9)
  3. Universal Connection Pool classes for use with JDK 8
  1. (10,602 bytes) - Sample security policy file for Oracle Database JDBC drivers
  1. (302,479 bytes)
  2. (SHA1 Checksum: ef6e535d008b82cf4bf3d1831a5c1ee6e18122a8)
  3. Additional jar required to access Oracle Wallets from Java
  1. (203,111 bytes)
  2. (SHA1 Checksum: be4a6d41c20d47e23e3b818c5b56968b225ccfba)
  3. Additional jar required to access Oracle Wallets from Java
  1. (292,104 bytes)
  2. (SHA1 Checksum: 47b52cf6525aecdda1feddb4e171386783374c89)
  3. Additional jar required to access Oracle Wallets from Java
  1. (1,661,088 bytes)
  2. (SHA1 Checksum: a569c1304c519d5de820daba00d5b8a6a6f798ab) - Classes for NLS support
  1. (259,806 bytes)
  2. (SHA1 Checksum: bb2ddfae79de117e2b7098fb457a8886a0caf78e)
  3. Classes to support standard JDBC 4.x java.sql.SQLXML interface (Java SE 8 & Java SE 7).
  1. (139,977 bytes)
  2. (SHA1 Checksum: 8f9b5f122cd9485ab1b51ce4fd0857d50cfcf1df)
  3. For use by the pure Java client-side Oracle Notification Services (ONS) daemon
  1. (29,051 bytes)
  2. (SHA1 Checksum: 5a33df223ad23ab8077791a5a689ca11b404837f)
  3. Java APIs for subscribing to RAC events via ONS; simplefan policy and javadoc

Oracle Database 19c and 18c JDBC drivers introduce a new property file (ojdbc.properties) along with few other features that simplifies the connection to Autonomous Transaction Processing (ATP) and Autonomous Data Warehousing (ADW). The Oracle JDBC driver class that implements the java.sql.Driver interface. Register the JDBC drivers To access a database from a Java application, you must first provide the code to register your installed driver with your program. You do this with the static registerDriver method of the java.sql.DriverManager class. The JDBC-ODBC bridge driver uses ODBC driver to connect to the database. The JDBC-ODBC bridge driver converts JDBC method calls into the ODBC function calls. This is now discouraged because of thin driver.

Driver

A JDBC example to show you how to connect to a Oracle database with a JDBC driver.

Tested with:

  • Java 8
  • Oracle database 19c
  • Oracle JDBC driver for Java 8, ojdbc8.jar

1. Download Oracle JDBC Driver

Visit Oracle database website and download the Oracle JDBC Driver.

Oracle

2. JDBC Connection

Note
Find your Oracle SID in {ORACLE_HOME}/network/admin/tnsnames.ora to avoid the popular ORA-12505, TNS:listener does not currently know of SID

2.1 Make a connection to the Oracle database.

Compile and run:

2.2 Assume ojdbc8.jar and JDBCExample.java are stored in c:test together. Define a -cp option to load everything together:

3. Maven Project

3.1 Sorry, due to Oracle license restriction, the Oracle JDBC driver is NOT available in the Maven central repository. Follow this guide to add it – How to add Oracle JDBC driver in your Maven local repository

3.2 Alternatively, defined a system scope to find the .jar file with a specified system path.

pom.xml

Download Source Code

Java Oracle Jdbc Driver

Oracle 12c Jdbc Driver Download

$ git clone https://github.com/mkyong/java-jdbc.git

Jdbc Url Oracle Example

References

About the Author

mkyong
Founder of Mkyong.com, love Java and open source stuff. Follow him on Twitter. If you like my tutorials, consider make a donation to these charities.

Comments