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