Preparing the MySQL Environment

In this section:

How to:

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.

In order to report against Unicode data in MySQL, you must enable Unicode support in the reporting server. For more information, seeMySQL and Unicode.


Top of page

x
Procedure: How to Prepare the MySQL Environment on Windows
  1. Specify the location of the MySQL Connector/JDBC driver files in the CLASSPATH environment variable. You must specify the full location and name of the jar file. For example, if the jar file is located in C:\Program Files\MySQL\JDBC Driver, then specify:
    CLASSPATH= C:\Program Files\MySQL\JDBC Driver\mysql-connector-java-5.1.17-bin.jar
  2. Specify the location of the Javarun time environment or development kit in the JAVA_HOME or JDK_HOME environment variable. Either is acceptable.

    You must specify the location where the run time environment is installed. You should see a sub-directory bin in that directory. For example, if you have the run time environment in C:\Program Files\java\jre6 then specify:

    JAVA_HOME=C:\Program Files\java\jre6

    Alternately, if you have the full development kit installed in C:\Program Files\java\jdk1.6.0_17, then specify:

    JDK_HOME= C:\Program Files\java\jdk1.6.0_17
  3. Start (or restart) the server.

Note: You also need to restart the server if the driver has changed.


Top of page

x
Procedure: How to Prepare the MySQL Environment on UNIX

Specify the location of several files:

  1. Specify the location of the MySQL Connector/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/mydriver.jar;$CLASSPATH 
    export CLASSPATH

    To ensure that the variable is set before server startup, add the CLASSPATH setting in your UNIX profile.

    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.
  2. 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
  3. 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.

  4. Start (or restart) the server.

Note: You also need to restart the server if the driver has changed.


Top of page

x
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.


iWay Software