SQL/MX 3.2 Guide to Stored Procedures in Java (H06.25+, J06.14+)

Getting Started
HP NonStop SQL/MX Release 3.2 Guide to Stored Procedures in Java—691166-001
2-5
Configuring the SPJ Environment on Systems
Running H-Series RVUs
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 on page 2-5

Java Library Path for the JDBC/MX Native Library on page 2-5

UDR Extensions Class Path for the JDBC/MX JAR File on page 2-6
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 default JREHOME location, which is
/usr/tandem/java/jre.
To use the JREHOME location, see Setting the JREHOME Location on page 2-13.
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.