Documentation Home
MySQL Connector/J 8.0 Developer Guide
Related Documentation Download this Manual
PDF (US Ltr) - 0.5Mb
PDF (A4) - 0.5Mb
HTML Download (TGZ) - 125.7Kb
HTML Download (Zip) - 146.0Kb


MySQL Connector/J 8.0 Developer Guide

Abstract

This manual describes how to install, configure, and develop database applications using MySQL Connector/J 8.0, a JDBC and X DevAPI driver for communicating with MySQL servers.

MySQL Connector/J 8.0 is highly recommended for use with MySQL Server 8.0, 5.7, and 5.6. Please upgrade to MySQL Connector/J 8.0.

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

For legal information, including licensing information, see the Preface and Legal Notices.

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

Document generated on: 2020-08-01 (revision: 66876)

Table of Contents

Preface and Legal Notices
1 Overview of MySQL Connector/J
2 Connector/J Versions, and the MySQL and Java Versions They Require
3 What's New in Connector/J 8.0?
4 Connector/J Installation
4.1 Installing Connector/J from a Binary Distribution
4.2 Installing Connector/J Using Maven
4.3 Installing from Source
4.4 Upgrading from an Older Version
4.4.1 Upgrading to MySQL Connector/J 8.0
4.5 Testing Connector/J
5 Connector/J Examples
6 Connector/J Reference
6.1 Driver/Datasource Class Name
6.2 Connection URL Syntax
6.3 Configuration Properties
6.4 JDBC API Implementation Notes
6.5 Java, JDBC, and MySQL Types
6.6 Using Character Sets and Unicode
6.7 Connecting Securely Using SSL
6.8 Connecting Using Unix Domain Sockets
6.9 Connecting Using Named Pipes
6.10 Connecting Using PAM Authentication
6.11 Using Source/Replica Replication with ReplicationConnection
6.12 Support for DNS SRV Records
6.13 Mapping MySQL Error Numbers to JDBC SQLState Codes
7 JDBC Concepts
7.1 Connecting to MySQL Using the JDBC DriverManager Interface
7.2 Using JDBC Statement Objects to Execute SQL
7.3 Using JDBC CallableStatements to Execute Stored Procedures
7.4 Retrieving AUTO_INCREMENT Column Values through JDBC
8 Connection Pooling with Connector/J
9 Multi-Host Connections
9.1 Configuring Server Failover for Connections Using JDBC
9.2 Configuring Server Failover for Connections Using X DevAPI
9.3 Configuring Load Balancing with Connector/J
9.4 Configuring Source/Replica Replication with Connector/J
9.5 Advanced Load-balancing and Failover Configuration
10 Using the X DevAPI with Connector/J: Special Topics
10.1 Connection Compression Using X DevAPI
10.2 Schema Validation
11 Using the Connector/J Interceptor Classes
12 Using Logging Frameworks with SLF4J
13 Using Connector/J with Tomcat
14 Using Connector/J with JBoss
15 Using Connector/J with Spring
15.1 Using JdbcTemplate
15.2 Transactional JDBC Access
15.3 Connection Pooling with Spring
16 Troubleshooting Connector/J Applications
17 Known Issues and Limitations
18 Connector/J Support
18.1 Connector/J Community Support
18.2 How to Report Connector/J Bugs or Problems
Index