3.5.3 Configuration Properties

3.5.3.1 Authentication

3.5.3.2 Connection

3.5.3.3 Session

3.5.3.4 Networking

3.5.3.5 Security

3.5.3.6 Statements

3.5.3.7 Prepared Statements

3.5.3.8 Result Sets

3.5.3.9 Metadata

3.5.3.10 BLOB/CLOB processing

3.5.3.11 Datetime types processing

3.5.3.12 High Availability and Clustering

3.5.3.13 Performance Extensions

3.5.3.14 Debugging/Profiling

3.5.3.15 Exceptions/Warnings

3.5.3.16 Tunes for integration with other products

3.5.3.17 JDBC compliance

3.5.3.18 X Protocol and X DevAPI

Configuration properties define how Connector/J will make a connection to a MySQL server. Unless otherwise noted, properties can be set for a DataSource object or for a Connection object.

Configuration properties can be set in one of the following ways:

• Using the set*() methods on MySQL implementations of java.sql.DataSource (which is the preferred method when using implementations of java.sql.DataSource):

  • com.mysql.cj.jdbc.MysqlDataSource

  • com.mysql.cj.jdbc.MysqlConnectionPoolDataSource

• As a key-value pair in the java.util.Properties instance passed to DriverManager.getConnection() or Driver.connect()

• As a JDBC URL parameter in the URL given to java.sql.DriverManager.getConnection(), java.sql.Driver.connect() or the MySQL implementations of the javax.sql.DataSource setURL() method. If you specify a configuration property in the URL without providing a value for it, nothing will be set; for example, adding useServerPrepStmts alone to the URL does not make Connector/J use server-side prepared statements; you need to add useServerPrepStmts=true.

  Note

  If the mechanism you use to configure a JDBC URL is XML-based, use the XML character literal & to separate configuration parameters, as the ampersand is a reserved character for XML.

The properties are listed in the following tables.