Java JDBC Example with Oracle Database Driver Connection

Post Banner

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(  {
                System.out.println(resultSet.getInt(1)+"  "+resultSet.getString(2));
        } catch (SQLException e) {
            System.out.println("Error occured while executing query: " + SQL_QUERY);


Facing issues? Have Questions? Post them here! I am happy to answer!

Author Info:

Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail:

Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap