Connect to Oracle Database using JDBC Thin Driver

Overview

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 SCOTT schema on a pluggable database named orclpdb.

Checklist

Oracle Database

Install the database, if you do not already have an Oracle Database installed. Sample steps to install Oracle on 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

tnsnames File Oracle TestingDocs

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());
 }
}