Preparing the Hyperstage Environment

In this section:

How to:

The Adapter for Hyperstage requires the MySQL Connector/J JDBC driver. The Adapter for Hyperstage PG uses the Postgres Connector/J JDBC driver. Where required to differentiate between settings for each version, the Posgres version is referred to as the Adapter for Hyperstage PG.


Top of page

x
Procedure: How to Prepare the Hyperstage Environment on Windows
  1. Specify the location of the Postgres or MySQL Connector/J JDBC driver file in the CLASSPATH environment variable. You must specify the full location and name of the jar file.

    For example, for the mySQL version, if the jar file is located in C:\Program Files\Hyperstage\JDBC Driver, then specify:

    CLASSPATH= C:\Program Files\Hyperstage\JDBC Driver\mysql-connector-java-5.1.18-bin.jar

    For example, for the Hyperstage PG version, if the jar file is located in CC:\ibi\srv99\homeHyperstage\hs\java, then specify:

    CLASSPATH= C:\ibi\srv99\homeHyperstage\hs\java\postgresql-9.2-1003.jdbc3.jar

    or

    CLASSPATH= C:\ibi\srv99\homeHyperstage\hs\java\postgresql-9.2-1003.jdbc4.jar
  2. Specify the location of the Java run 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 Hyperstage Environment on UNIX

Specify the location of several files:

  1. Specify the location of the MySQL Connector/J JDBC driver files in the $CLASSPATH environment variable.

    For example, if the file is located in /usr/driver_files, you would issue the following statements for the mySQL version:

    CLASSPATH=/usr/driver_files/mysql-connector-java-5.1.18-bin.jar;$CLASSPATH 
    export CLASSPATH

    For example, if the file is located in /usr/driver_files, you would issue the following statements for the Hyperstage PG version:

    CLASSPATH=/usr/driver_files/postgresql-9.2-1003.jdbc4.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. Select the Workspace menu option.
    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
Hyperstage and Unicode

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


WebFOCUS