Preparing the MySQL Environment

The Adapter for MySQL requires the MySQL Connector/J JDBC driver. For Release 5.x, Version 5.0.4 or higher is required. For Release 3.x, Version 3.1.14 or higher is required.

Procedure: How to Prepare the MySQL Environment on Windows

Specify the location of the MySQL Connector/JDBC driver in the CLASSPATH environment variable.

Procedure: How to Prepare the MySQL Environment on UNIX

Specify the location of several files:

Specify the location of the MySQL Connector/J JDBC driver files in the $CLASSPATH environment variable.
For example, if the files are located in /usr/driver_files, you would issue the following statements:
```
CLASSPATH=/usr/driver_files/driver_files.jar
export CLASSPATH
```
Alternatively, you could use the Web Console to specify the location:
1. From the Workspace menu, select Configuration/Monitor.
2. Expand the Java Services folder, right-click DEFAULT, and select Properties.
  The Java Services Configuration pane opens.
3. Select the Class path section.
4. Specify the full path to the MySQL Connector/J jar file in the IBI_CLASSPATH field.
5. Click Save and Restart Java Services.
Specify the location of the Java Development Kit's installation directory in the $JDK_HOME environment variable.
For example, if you want to set the location of the Java Development Kit to /usr/java, you would issue the following statements:
```
JDK_HOME=/usr/java 
export JDK_HOME
```
Specify the location of the Java Virtual Machine's installation directory in the $LD_LIBRARY_PATH environment variable.
For example, if you want to set the location of the JVM to /usr/j2sdk1.4.2_01/jre/lib/i386/server, you would issue the following statements:
```
LD_LIBRARY_PATH=/usr/j2sdk1.4.2_01/jre/lib/i386/server
export LD_LIBRARY_PATH
```
Note that if the server is running with security on, the LD_LIBRARY_PATH variable is ignored. In this case, you must use IBI_LIBPATH.

MySQL and Unicode

The Adapter for MySQL is implemented using JDBC. This implementation supports Unicode data stored in character fields with the CHARACTER SET set to UTF-8.

You must set the LANG environment variable in the edastart file or in a separate shell file before you start the server. For example, for American English you would export the following variable:

export LANG=EN_US.UTF-8

For details, see Unicode Support in the Server Administration for UNIX, Windows, OpenVMS, IBM i, and z/OS manual.