Overview

JDBC DriverManager class is an important class and the backbone of JDBC architecture. DriverManager is the basic service for managing a set of JDBC drivers that are installed on the system.

getConnection()

When the method getConnection() is invoked, DriverManager will attempt to locate and load a suitable JDBC driver. The getConnection() method is used to establish a connection to a given database URL.

Import DriverManager

We can import the class in the Java application from the java.sql package.

import java.sql.DriverManager;

Code Example

String driverName = "oracle.jdbc.driver.OracleDriver";
String hostName = "localhost";
String portNumber = "1521";
String serviceName = "orclpdb.localdomain";
String username="scott";
String password="tiger";
String url = "jdbc:oracle:thin:@//" + hostName + ":" + 
 portNumber + "/" + serviceName ;
try {
 // Load the Oracle JDBC driver
 Class.forName(driverName);
Connection connection = 
DriverManager.getConnection(url, username, password);
 } catch (Exception exp) {
 System.out.println("Exception : "
 +exp.getMessage());
 }

JDBC driver initialization is done lazily by the DriverManager. It looks up the service providers using the thread context class loader. DriverManager class will attempt to load available JDBC drivers by using jdbc.drivers system property. The system property can contain a colon separated list of fully qualified class names of the JDBC drivers.

The following code loads the Oracle JDBC thin driver and the DriverManager.getConnection() method attempts to establish a database connection to the SCOTT scheme in the pluggable database orclpdb. If the connection could not connect to the database an exception SQLException is thrown.