DataMigrator/Reporting Server > Using the Adapter for MariaDB > Preparing the MariaDB Environment

Preparing the MariaDB Environment

Topics:

How to:

The Adapter for MariaDB requires the MariaDB Connector/J JDBC driver.

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

Procedure: How to Prepare the MariaDB Environment on Windows

  1. Specify the location of the MariaDB 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\MariaDB\JDBC Driver, then specify:
    CLASSPATH= C:\Program Files\MariaDB\JDBC Driver/mariadb-java-client-1.5.3.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\jre7 then specify: 

    JAVA_HOME=C:\Program Files\java\jre7

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

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

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

Procedure: How to Prepare the MariaDB Environment on UNIX

Specify the location of several files:

  1. Specify the location of the MariaDB 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 Java Services.
    2. 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 MariaDB 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.7.0_05/jre/lib/i386/server, you would issue the following statements: 

    LD_LIBRARY_PATH=/usr/j2sdk1.7.0_05/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.

MariaDB and Unicode

The Adapter for MariaDB 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.

WebFOCUS

Feedback