Chapter 3 MySQL Connector/J Developer Guide

Table of Contents

3.1 Overview of MySQL Connector/J

3.2 Compatibility with MySQL and Java Versions

3.3 Connector/J Installation

3.3.1 Installing Connector/J from a Binary Distribution

3.3.2 Installing Connector/J Using Maven

3.3.3 Installing from Source

3.3.4 Upgrading from an Older Version

3.3.5 Testing Connector/J

3.4 Connector/J Examples

3.5 Connector/J Reference

3.5.1 Driver/Datasource Class Name

3.5.2 Connection URL Syntax

3.5.3 Configuration Properties

3.5.4 JDBC API Implementation Notes

3.5.5 Java, JDBC, and MySQL Types

3.5.6 Handling of Date-Time Values

3.5.7 Using Character Sets and Unicode

3.5.8 Using Query Attributes

3.5.9 Connecting Securely Using SSL

3.5.10 Connecting Using Unix Domain Sockets

3.5.11 Connecting Using Named Pipes

3.5.12 Connecting Using Various Authentication Methods

3.5.13 Using Source/Replica Replication with ReplicationConnection

3.5.14 Support for DNS SRV Records

3.5.15 Client Session State Tracker

3.5.16 Mapping MySQL Error Numbers to JDBC SQLState Codes

3.6 JDBC Concepts

3.6.1 Connecting to MySQL Using the JDBC DriverManager Interface

3.6.2 Using JDBC Statement Objects to Execute SQL

3.6.3 Using JDBC CallableStatements to Execute Stored Procedures

3.6.4 Retrieving AUTO_INCREMENT Column Values through JDBC

3.7 Connection Pooling with Connector/J

3.8 Multi-Host Connections

3.8.1 Configuring Server Failover for Connections Using JDBC

3.8.2 Configuring Server Failover for Connections Using X DevAPI

3.8.3 Configuring Load Balancing with Connector/J

3.8.4 Configuring Source/Replica Replication with Connector/J

3.8.5 Advanced Load-balancing and Failover Configuration

3.9 Using the X DevAPI with Connector/J: Special Topics

3.9.1 Connection Compression Using X DevAPI

3.9.2 Schema Validation

3.10 Using the Connector/J Interceptor Classes

3.11 Using Logging Frameworks with SLF4J

3.12 Using Connector/J with Tomcat

3.13 Using Connector/J with Spring

3.13.1 Using JdbcTemplate

3.13.2 Transactional JDBC Access

3.13.3 Connection Pooling with Spring

3.14 Troubleshooting Connector/J Applications

3.15 Known Issues and Limitations

3.16 Connector/J Support

3.16.1 Connector/J Community Support

3.16.2 How to Report Connector/J Bugs or Problems

MySQL Connector/J is a JDBC driver for communicating with MySQL servers.

For notes detailing the changes in each release of Connector/J, see MySQL Connector/J Release Notes.

For legal information, see the Legal Notices.

For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.

Licensing information.  This product may include third-party software, used under license. If you are using a Commercial release of MySQL Connector/J, see this document for licensing information, including licensing information relating to third-party software that may be included in this Commercial release. If you are using a Community release of MySQL Connector/J, see this document for licensing information, including licensing information relating to third-party software that may be included in this Community release.