In this example we shall show you how to connect to Oracle Database. To connect to Oracle Database one should perform the following steps:
- Load the
oracle.jdbc.driver.OracleDriver, using theforName(String className)API method of the Class, in order to connect to Oracle Database. - Create a Connection to the database. Invoke the
getConnection(String url, String user, String password)API method of the DriverManager to create the connection. - The parameters should be the database url, the database user on whose behalf the connection is being made and the user’s password,
as described in the code snippet below.
package com.javacodegeeks.snippets.core;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConnectToOracle {
public static void main(String[] args) {
Connection connection = null;
try {
// Load the Oracle JDBC driver
String driverName = "oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
// Create a connection to the database
String serverName = "localhost";
String serverPort = "1521";
String sid = "mySchema";
String url = "jdbc:oracle:thin:@" + serverName + ":" + serverPort + ":" + sid;
String username = "username";
String password = "password";
connection = DriverManager.getConnection(url, username, password);
System.out.println("Successfully Connected to the database!");
} catch (ClassNotFoundException e) {
System.out.println("Could not find the database driver " + e.getMessage());
} catch (SQLException e) {
System.out.println("Could not connect to the database " + e.getMessage());
}
}
}
Output:
Successfully Connected to the database!
This was an example of how to connect to Oracle Database in Java.
