Once you have extracted the distribution archive, you can
install the driver by placing
mysql-connector-java-in your classpath, either by adding the full path to
it to your
CLASSPATH environment variable, or
by directly specifying it with the command line switch
-cp when starting the JVM.
To use the driver with the JDBC
com.mysql.jdbc.Driver as the class that
You can set the
variable under Unix, Linux or Mac OS X either locally for a user
.login or other login file. You can also set
it globally by editing the global
For example, add the Connector/J driver to your
CLASSPATH using one of the following forms,
depending on your command shell:
# Bourne-compatible shell (sh, ksh, bash, zsh): shell> export CLASSPATH=/path/mysql-connector-java-
ver-bin.jar:$CLASSPATH # C shell (csh, tcsh): shell> setenv CLASSPATH /path/mysql-connector-java-
Within Windows 2000, Windows XP, Windows Server 2003 and Windows Vista, you set the environment variable through the System Control Panel.
To use MySQL Connector/J with an application server such as
GlassFish, Tomcat, or JBoss, read your vendor's documentation
for more information on how to configure third-party class
libraries, as most application servers ignore the
CLASSPATH environment variable. For
configuration examples for some J2EE application servers, see
Chapter 7, Connection Pooling with Connector/J
Section 8.1, “Configuring Load Balancing with Connector/J”,
Section 8.2, “Configuring Failover with Connector/J”.
However, the authoritative source for JDBC connection pool
configuration information for your particular application server
is the documentation for that application server.
If you are developing servlets or JSPs, and your application
server is J2EE-compliant, you can put the driver's
.jar file in the
WEB-INF/lib subdirectory of your webapp, as
this is a standard location for third party class libraries in
J2EE web applications.
You can also use the
MysqlConnectionPoolDataSource classes in
com.mysql.jdbc.jdbc2.optional package, if
your J2EE application server supports or requires them. Starting
with Connector/J 5.0.0, the
javax.sql.XADataSource interface is
implemented using the
class, which supports XA distributed transactions when used in
combination with MySQL server version 5.0.
support the following parameters (through standard set
serverName (see the previous section
about fail-over hosts)