JDBC : Load JDBC Driver

🚀 Master Java database programming and JDBC fundamentals!

🔔 Subscribe to Ram N Java on YouTube

Step 1: Download & Configure the MySQL JDBC Driver

Before your Java application can talk to a MySQL database, it requires the vendor-specific JDBC driver library (MySQL Connector/J):

• Visit the official MySQL downloads site and choose MySQL Connector/J.
• Select the Platform Independent option to download the ZIP distribution.
• Extract the archive to locate the driver JAR file (e.g., mysql-connector-java.jar).
• Add this JAR file to your project's lib folder and ensure it is included in your Java classpath.

Java Program: Loading Driver and Connecting

Here is the complete Java code showing how to dynamically load the driver class and open a database connection using DriverManager:

package com.ram.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class LoadJDBCDriverDemo {

    static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    static final String DB_URL = "jdbc:mysql://localhost:3306/world";
    static final String USER = "root";
    static final String PASS = "root";

    public static void main(String[] args) {
        LoadJDBCDriverDemo demo = new LoadJDBCDriverDemo();
        demo.loadDriverAndConnect();
    }

    public void loadDriverAndConnect() {
        Connection conn = null;
        try {
            // Step 1: Load and register MySQL driver
            Class.forName(JDBC_DRIVER);
            System.out.println("Driver loaded successfully!");

            // Step 2: Establish connection via DriverManager
            conn = DriverManager.getConnection(DB_URL, USER, PASS);
            System.out.println("Connection established successfully: " + conn);

        } catch (ClassNotFoundException e) {
            System.err.println("JDBC Driver not found in classpath!");
            e.printStackTrace();
        } catch (SQLException e) {
            System.err.println("Failed to connect to database!");
            e.printStackTrace();
        } finally {
            try {
                if (conn != null) {
                    conn.close();
                    System.out.println("Connection closed.");
                }
            } catch (SQLException se) {
                se.printStackTrace();
            }
        }
    }
}

Behind the Scenes: How Class.forName() Registers the Driver

How does calling Class.forName("com.mysql.jdbc.Driver") make DriverManager aware of the driver?

When you decompile com.mysql.jdbc.Driver from the JAR, you will see a static initialization block defined inside the class:

static {
    try {
        java.sql.DriverManager.registerDriver(new Driver());
    } catch (SQLException E) {
        throw new RuntimeException("Can't register driver!");
    }
}

When Class.forName() loads the class into memory, the JVM executes this static block immediately, automatically creating an instance of the driver and registering it with DriverManager.

Related Tutorials You Might Enjoy

• JDBC DriverManager: What It Is and How It Works | JDBC Tutorial
• JDBC Driver Overview: Everything You Need to Know
• Java Decompiler Demystified: Understanding Reverse Engineering

---

Click here to watch in Youtube : https://www.youtube.com/watch?v=fA539fwWtHY

Click the below Image to Enlarge

JDBC : Load JDBC Driver

JDBC : Load JDBC Driver

JDBC : Load JDBC Driver

JDBC : Load JDBC Driver

JDBC : Load JDBC Driver

JDBC : Load JDBC Driver

LoadJDBCDriver.java