Chapter 6 Connector/J Reference

Table of Contents

6.1 Driver/Datasource Class Name

6.2 Connection URL Syntax

6.3 Configuration Properties

6.3.1 Authentication

6.3.2 Connection

6.3.3 Session

6.3.4 Networking

6.3.5 Security

6.3.6 Statements

6.3.7 Prepared Statements

6.3.8 Result Sets

6.3.9 Metadata

6.3.10 BLOB/CLOB processing

6.3.11 Datetime types processing

6.3.12 High Availability and Clustering

6.3.13 Performance Extensions

6.3.14 Debugging/Profiling

6.3.15 Exceptions/Warnings

6.3.16 Tunes for integration with other products

6.3.17 JDBC compliance

6.3.18 X Protocol and X DevAPI

6.4 JDBC API Implementation Notes

6.5 Java, JDBC, and MySQL Types

6.6 Handling of Date-Time Values

6.6.1 Preserving Time Instants

6.6.2 Fractional Seconds

6.6.3 Handling of YEAR Values

6.7 Using Character Sets and Unicode

6.8 Using Query Attributes

6.9 Connecting Securely Using SSL

6.9.1 Setting up Server Authentication

6.9.2 Setting up Client Authentication

6.9.3 Setting up 2-Way Authentication

6.9.4 JSSE in FIPS Mode

6.9.5 Debugging an SSL Connection

6.10 Connecting Using Unix Domain Sockets

6.11 Connecting Using Named Pipes

6.12 Connecting Using Various Authentication Methods

6.12.1 Connecting Using PAM Authentication

6.12.2 Connecting Using Kerberos

6.12.3 Connecting Using Multifactor Authentication

6.12.4 Connecting Using Fast Identity Online (FIDO) Authentication

6.12.5 Connecting Using Web Authentication (WebAuthn) Authentication

6.13 Using Source/Replica Replication with ReplicationConnection

6.14 Support for DNS SRV Records

6.15 Client Session State Tracker

6.16 Mapping MySQL Error Numbers to JDBC SQLState Codes

This section of the manual contains reference material for MySQL Connector/J.