MySQL Connector/J - Download and Installation

This section describes how to download and install MySQL Connector/J (JDBC driver).

With MySQL server installed and running, I am ready to try the JDBC driver to access my MySQL server. Here is what I did to download and install MySQL JDBC driver:

The installation is done. You should read the documentation at https://dev.mysql.com/doc/connector-j/8.0/en/. Some version information of MySQL Connector/J 8.0.27 is summarized here:

Note that the MySQL JDBC driver class name has been changed from "com.mysql.jdbc.Driver" to "com.mysql.cj.jdbc.Driver".

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 Connector/J - Download and Installation

 Loading JDBC Driver for MySQL Server

 JDBC Driver Connection URL

 Specifying Timezone During Connection

 Creating Connections with DataSource Class

 Getting Driver and Server Information

 Creating Tables with AUTO_INCREMENT Columns

 "INSERT INTO" Statements

 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

 References

 Full Version in PDF/EPUB