MySQL Connector/J 5.1 Developer Guide
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.jdbc.jdbc2.optional.MysqlDataSource
com.mysql.jdbc.jdbc2.optional.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.
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 configuration properties are categorized into the following sections, in which details for each property are given.