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.
