Connect to Oracle Database using JDBC

In this tutorial, we will learn the steps to connect to Oracle Database using JDBC Thin Driver in Java programming language. In this example, we will connect to the SCOTT schema on a pluggable database named orclpdb.

Checklist

• Oracle Database

Install the database, if you do not already have an Oracle Database installed. The sample steps to install Oracle on the Windows operating system:

https://www.testingdocs.com/install-oracle-19c-database-on-windows-10/

For Detailed Steps follow the vendor’s instructions for the database installation.

• JDK
• Sample Scheme setup

Instructions to setup the sample SCOTT schema can be found here:

https://www.testingdocs.com/setting-up-sample-schema-in-oracle/

• Oracle JDBC Thin Driver
• Eclipse/ IntelliJ IDE

Oracle JDBC Thin Driver

The JDBC driver can be found at the following location on the database machine:

%ORACLE_HOME%\jdbc\lib

For standalone Java project add the JDBC jar file to the project build path.

Connection Descriptor

The connection descriptor string should be formed using the tnsnames.ora file from the database instance that we are trying to establish the connection. The exact hostname, port, and the service name can be found in the tnsnames.ora file.

On Windows the file can be found at the following path: %ORACLE_HOME%\network\admin

Java Sample Program

 

import java.sql.*;
import oracle.jdbc.pool.OracleDataSource;

/*********************************************
 * Oracle JDBC Thin Driver Demo
 * Print JDBC Version Information
 * Java Tutorials - www.TestingDocs.com
 * 
 * @author testingdocs
 *
 *********************************************/
public class OracleThinJDBCVersion
{
 public static void main (String args[])
 throws SQLException
 {
 OracleDataSource ods = new OracleDataSource();
 ods.setURL("jdbc:oracle:thin:scott/tiger@
//localhost:1521/orclpdb.localdomain");
 Connection connection = ods.getConnection();
 // Create Oracle DatabaseMetaData Object
 DatabaseMetaData meta = connection
.getMetaData();
 // Display JDBC Driver Version Info
 System.out.println("Oracle JDBC Thin Driver
 Version: " + meta.getDriverVersion());
 }
}

Screenshot

The program connects to the Oracle database and prints the JDBC version on to the console window.

 

Java Tutorials

Java Tutorial on this website:

https://www.testingdocs.com/java-tutorial/