Java JDBC Connection to Oracle Database Example

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

Learn a complete JDBC tutorial at https://www.javaguides.net/p/jdbc-tutorial.html.

JDBC Connection to Oracle Database Example

Download the Ojdbc8.jar file and add it to the classpath of your project.

For the maven project, use below maven dependency:

<!-- https://mvnrepository.com/artifact/com.oracle.jdbc/ojdbc8 -->
<dependency>
    <groupId>com.oracle.jdbc</groupId>
    <artifactId>ojdbc8</artifactId>
    <version>12.2.0.1</version>
</dependency>

Here is the JDBC example to connect to an Oracle database with a JDBC driver:

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

public class JDBCExample {

    public static void main(String[] args) {

        // Oracle SID = orcl , find yours in tnsname.ora
        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();
        }

    }
}

Output:

Connected to the database!

References

https://www.javaguides.net/p/jdbc-tutorial.html.

Related JDBC Source Code Examples

• JDBC Create a Table Example
• JDBC Insert Multiple Rows Example
• JDBC Update Query Example
• JDBC Select Query Example
• JDBC Delete Query Example
• JDBC Transaction Management Example
• JDBC Connection to Oracle Database Example
• JDBC Connection to PostgreSQL Example
• JDBC Connection to H2 Database Example
• Java JDBC Connection to HSQLDB Database
• Java PostgreSQL Example
• Java H2 Create Table Example
• Java H2 Insert Record Example
• Java H2 Embedded Database Example