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.
CLASSPATH= C:\Program Files\MySQL\JDBC Driver\mysql-connector-java-5.1.17-bin.jar
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
Note: You also need to restart the server if the driver has changed.
Specify the location of several files:
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:
The Java Services Configuration pane opens.
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
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.
Note: You also need to restart the server if the driver has changed.
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 |