SQL/MX 3.2.1 Guide to Stored Procedures in Java (H06.26+, J06.15+)

Configuring the SPJ Environment on Systems Running H-Series RVUs
On systems running H-series RVUs, the libraries of the NonStop Server for Java and the JDBC/MX
driver are not statically bound into the SQL/MX UDR server. Therefore, the SQL/MX UDR server
depends on these settings to use the correct versions of the NonStop Server for Java and the
JDBC/MX driver:
• JREHOME Setting for the NonStop Server for Java (page 35)
• Java Library Path for the JDBC/MX Native Library (page 35)
• UDR Extensions Class Path for the JDBC/MX JAR File (page 36)
JREHOME Setting for the NonStop Server for Java
To specify the location of the NonStop Server for Java for the SQL/MX UDR server, set the JREHOME
location by using one of these methods, listed in order of precedence from highest to lowest:
1. In the UDR_JAVA_OPTIONS default attribute, set -Dsqlmx.udr.jrehome to the location
of the NonStop Server for Java.
2. Set the JREHOME environment variable to the location of the NonStop Server for Java.
3. Let the SQL/MX UDR server use the location /usr/tandem/java/jre.
NOTE:
• Installation of NSJ7 does not automatically create the softlink /usr/tandem/java. If you
have migrated all applications to NSJ7, then HP recommends you to create a softlink manually
to point to the NSJ7 JDK/JRE installation (/usr/tandem/nssjava/jdk170_h70). Create
the softlink /usr/tandem/java to point to the NSJ7 home directory as follows:
$ ln -s /usr/tandem/nssjava/jdk170_h70 /usr/tandem/java
After creating this softlink, applications that rely on the softlink might fail if they are not migrated
to NSJ7.
• SPJs can be created through the NSM/web, and since the installation of NSJ7 does not
automatically create the softlink /usr/tandem/java, you must use the method 1 or 3.
Method 2 is not supported for NSM/web.
To use the JREHOME location, see Setting the JREHOME Location (page 40).
Java Library Path for the JDBC/MX Native Library
To load a native library, the JVM requires the directory of a native library to be specified in the
java.library.path property. The same requirement applies to the JVM of the SQL/MX UDR
server, which requires the directory of the JDBC/MX native library, libjdbcMx.so, to be in the
java.library.path. The SQL/MX UDR server always appends the standard location of the
JDBC/MX native library, /usr/tandem/jdbcMx/current/lib, to the end of the
java.library.path.
To specify the location of the JDBC/MX native library, set the library path by using one of these
methods, listed in order of precedence from highest to lowest:
1. In the UDR_JAVA_OPTIONS default attribute, set -Djava.library.path to the location
of the JDBC/MX native library. The JVM of the SQL/MX UDR server uses this setting as the
java.library.path property.
2. Set the _RLD_LIB_PATH environment variable to the location of the JDBC/MX native library.
The JVM of the SQL/MX UDR server uses this setting as the java.library.path property.
3. Let the JVM of the SQL/MX UDR server use the standard location of the JDBC/MX native
library, which the SQL/MX UDR server automatically appends to the java.library.path
property.
Configuring the SPJ Environment on Systems Running H-Series RVUs 35