Documentation Home
Connectors and APIs Manual
Download this Manual

Connectors and APIs Manual  /  MySQL Connector/J Developer Guide

Chapter 3 MySQL Connector/J Developer Guide

Table of Contents

3.1 Overview of MySQL Connector/J
3.2 Connector/J Versions, and the MySQL and Java Versions They Require
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 Using Character Sets and Unicode
3.5.7 Connecting Securely Using SSL
3.5.8 Connecting Using Unix Domain Sockets
3.5.9 Connecting Using Named Pipes
3.5.10 Connecting Using PAM Authentication
3.5.11 Using Master/Slave Replication with ReplicationConnection
3.5.12 Support for DNS SRV Records
3.5.13 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 Master/Slave Replication with Connector/J
3.8.5 Advanced Load-balancing and Failover Configuration
3.9 Using the Connector/J Interceptor Classes
3.10 Using Connector/J with Tomcat
3.11 Using Connector/J with JBoss
3.12 Using Connector/J with Spring
3.12.1 Using JdbcTemplate
3.12.2 Transactional JDBC Access
3.12.3 Connection Pooling with Spring
3.13 Troubleshooting Connector/J Applications
3.14 Known Issues and Limitations
3.15 Connector/J Support
3.15.1 Connector/J Community Support
3.15.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 8.0, 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 8.0, see this document for licensing information, including licensing information relating to third-party software that may be included in this Community release.