Loading JDBC Driver for MySQL Server

JDBC Tutorials - Herong's Tutorial Examples - Version 3.01, by Dr. Herong Yang

JDBC Tutorials - Herong's Tutorial Examples

∟Loading JDBC Driver for MySQL Server

This section describes how to load the MySQL JDBC driver class - mysql-connector-java-5.1.36-bin.jar.

If you are using JDK 1.8, it will automatically load the MySQL JDBC 5.1.36 driver, as long as the JAR file is included in the classpath. There is no need to call Class.forName("com.mysql.jdbc.Driver") to load the driver class explicitly Here is a tutorial program to show you how JDBC loads the MySQL JDBC 5.1.36 driver:

/* MySqlLoadDriver.java
 - Copyright (c) 2015, HerongYang.com, All Rights Reserved.
 */
import java.sql.*;
import java.util.*;
public class MySqlLoadDriver {
  public static void main(String [] args) {
    Connection con = null;
    try {
      System.out.println("Before loading SQLServerDriver:");
      listDrivers();

// Load the MySQL JDBC driver
      Class.forName("com.mysql.jdbc.Driver") ;
 
      System.out.println("After loading SQLServerDriver:");
      listDrivers();

    } catch (Exception e) {
      System.err.println("Exception: "+e.getMessage());
    }
  }
  private static void listDrivers() {
    Enumeration driverList = DriverManager.getDrivers();
    while (driverList.hasMoreElements()) {
      Driver driverClass = (Driver) driverList.nextElement();
      System.out.println("   "+driverClass.getClass().getName());
    }
  }
}

The compilation and execution tests with JDK 1.8 were recorded below:

C:\herong>\Progra~1\java\jdk1.8.0_45\bin\javac MySqlLoadDriver.java

C:\herong>\Progra~1\java\jdk1.8.0_45\bin\java 
   -cp .;\local\lib\mysql-connector-java-5.1.36-bin.jar
   MySqlLoadDriver

Before loading SQLServerDriver:
   com.mysql.jdbc.Driver
   com.mysql.fabric.jdbc.FabricMySQLDriver
After loading SQLServerDriver:
   com.mysql.jdbc.Driver
   com.mysql.fabric.jdbc.FabricMySQLDriver

Note that:

2 JDBC driver classes were loaded automatically before calling the Class.forName() to load them explicitly.
I am sure that the "com.mysql.jdbc.Driver" class is the JDBC driver class for the MySQL server.
I am not sure what the "com.mysql.fabric.jdbc.FabricMySQLDriver" driver class is for.

Last update: 2015.

Table of Contents

About This Book

JDBC (Java Database Connectivity) Introduction

JDK (Java SE) Installation

Installing and Running Java DB - Derby

Derby (Java DB) JDBC Driver

Derby (Java DB) JDBC DataSource Objects

Java DB (Derby) - DML Statements

Java DB (Derby) - ResultSet Objects of Queries

Java DB (Derby) - PreparedStatement

MySQL Installation on Windows