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(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();
        } 
    }

}


Have Questions? Post them here!
Advertisements
Try Out Code2care Dev Tools:

Advertisements

Advertisements
Code2care is an initiative to publish and share varied knowledge in programming and technical areas gathered during day-to-day learnings and development activities.

Students and software developers can leverage this portal to find solutions to their various queries without re-inventing the wheel by referring to our easy to understand posts. Technical posts might include learnings, tutorials, trouble-shooting steps, video tutorials, code snippets, how-to, blogs, articles, etc.

🎉 We are celebrating the 10th years of Code2care! Thank you for all your support!

We strongly support Gender Equality & Diversity.