Archived: Loading MySQL Connector Java 5.0

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

MySQL JDBC driver 5.0.7 is a JDBC 3.0 driver. The driver class, com.mysql.jdbc.Driver, needs to be loaded, if you want to use the DriverManager class to create Connection objects. The simplest way to load a driver class is to call the Class.forName() method as shown in the following sample program. Of course, you have to include the mysql-connector-java-5.0.7-bin.jar file in the classpath when you execute this program:

/* MySqlLoadDriver.java
 * Copyright (c) HerongYang.com. All Rights Reserved.
 */
import java.sql.*;
public class MySqlLoadDriver {
  public static void main(String [] args) {
    Connection con = null;
    try {

// Load the MySQL JDBC driver
      Class.forName("com.mysql.jdbc.Driver") ;
      System.out.println("MySQL JDBC driver loaded ok.");

    } catch (Exception e) {
      System.err.println("Exception: "+e.getMessage());
    }
  }
}

The compilation and execution tests were recorded below. Notice the exception error I got without mysql-connector-java-5.0.7-bin.jar in the classpath:

herong> javac MySqlLoadDriver.java

herong> java MySqlLoadDriver
Exception: com.mysql.jdbc.Driver

herong> java -cp .;\local\lib\mysql-connector-java-5.0.7-bin.jar
  MySqlLoadDriver

MySQL JDBC driver loaded ok.

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 JDK (Java SE) Installation

 MySQL Installation on Windows

 MySQL JDBC Driver (MySQL Connector/J)

 MySQL - PreparedStatement

 MySQL - Reference Implementation of JdbcRowSet

 MySQL - JBDC CallableStatement

 MySQL CLOB (Character Large Object) - TEXT

 MySQL BLOB (Binary Large Object) - BLOB

 Using Connection Pool with JDBC

Archived Tutorials

 Archived: Downloading and Installing JDK on Windows

 Archived: Java SE 8 Installation

 Archived: Java SE 1.6 Update 2 Installation

 Archived: JDK 1.6 Documentation Installation

 Archived: Downloading/Installing Java DB (Derby) 10.2.2

 Archived: MySQL Connector/J 5.1 - Download and Installation

 Archived: MySQL 5.0 Download, Installation and Start

 Archived: mysqladmin - MySQL 5.0 Admin Tool

 Archived: MySQL Connector/J 5.0 - Download and Installation

Archived: Loading MySQL Connector Java 5.0

 Archived: Installation of JdbcRowSet Reference Implementation

 Archived: Oracle Database Express Edition (XE) Installation

 References

 Full Version in PDF/EPUB