Java JDBC Example with Oracle Database Driver Connection

In this Tutorial, we will take a look at how to connect to Oracle Database using Java JDBC and Oracle Driver Connection.

Step 1: Download JDBC Driver jar for Oracle

Based on which Java version that you are using you need to download the Oracle JDBC Driver from Oracle's website.

Java 8 and 11: ojdbc8.jar
Java 11 and 17: ojdbc11.jar

Also make sure to download the jar based on the Oracle Database Version like 18c, 19c, or 21c

⛏️ Download Link: Oracle Database JDBC driver and Companion Jars Downloads

Step 2: Add the Oracle JDBC jar to the Java Classpath

For Eclipse:

1. Right-Click on your Project Folder,
2. Now Select Build Path,
3. Now Click on Configure Build Path,
4. Now Click on Libraries -> Add External JARs,
5. Now select the Oracle JDBC jar./li>
6. Finally click and Apply and Ok.

Step 3: Java Code JDBC Connection using Oracle Database

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class JavaJDBCExampleWithOracleDB {

    private static String ORACLE_DB_URL = "jdbc:oracle:thin:@localhost:1521:my_oracle_db";
    private static String ORACLE_DB_USER = "root";
    private static String ORACLE_DB_USER_PASSWORD = "root1234";

    private static String SQL_QUERY = "Select * from users";


    public static void main(String[] args) {
            
        try(Connection connection = DriverManager.getConnection(ORACLE_DB_URL,ORACLE_DB_USER,ORACLE_DB_USER_PASSWORD)) {
            Statement statement =connection.createStatement();  
            ResultSet resultSet = statement.executeQuery(SQL_QUERY); 
            while(resultSet.next())  {
                System.out.println(resultSet.getInt(1)+"  "+resultSet.getString(2));
            }     
                
        } catch (SQLException e) {
            System.out.println("Error occured while executing query: " + SQL_QUERY);
            e.printStackTrace();
        } 
    }

}