coderz.py

Follow the steps below to connect a Java application to an Oracle database using Thin Driver.

• Download Oracle JDBC Driver
• Load Driver Class
• JDBC Connection
• Load the jar file

Download Oracle JDBC Driver:

Visit Oracle database website and download the Oracle JDBC Driver.

Load Driver Class:

The Oracle database Driver Class is oracle.jdbc.driver.OracleDriver and the Class.forName(“oracle.jdbc.driver.OracleDriver”) method is used to load the Oracle database driver class.

JDBC Connection:

Make a connection to the Oracle database by following the given syntax:

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "system", "Password123")

Load the jar file:

We can load the.jar file in one of two ways:

• Copy the jar file to the C:\Program Files\Java\jre7\lib\ext directory.
• Set it on the classpath.

Simple Example:

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

public class JDBCExample {

    public static void main(String[] args) {
        // register JDBC driver, optional since java 1.6
        /*try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }*/
  
        try (Connection conn = DriverManager.getConnection(
                "jdbc:oracle:thin:@localhost:1521:orcl", "system", "Password123")) {

            if (conn != null) {
                System.out.println("Connected to the database!");
            } else {
                System.out.println("Failed to make connection!");
            }

        } catch (SQLException e) {
            System.err.format("SQL State: %s\n%s", e.getSQLState(), e.getMessage());
        } catch (Exception e) {
            e.printStackTrace();
        }

    }
}

Note: also read about the Java connect to MySQL database with JDBC

Follow Me

If you like my post, please follow me to read my latest post on programming and technology.

https://www.instagram.com/coderz.py/

https://www.facebook.com/coderz.py