SQL/MX Guide to Stored Procedures in Java (H06.04+, J06.03+)

Getting Started
HP NonStop SQL/MX Guide to Stored Procedures in Java—540433-003
2-6
UDR Extensions Class Path for the JDBC/MX JAR
File
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.
To use UDR_JAVA_OPTIONS, see Controlling JVM Startup Options
on page 2-6. To
use the _RLD_LIB_PATH environment variable, see the
NonStop Server for Java
Programmer’s Reference
for SDK 1.4.2.
UDR Extensions Class Path for the JDBC/MX JAR File
By default, NonStop SQL/MX loads the jdbcMx.jar file of JDBC/MX from the
standard location of /usr/tandem/jdbcMx/current/lib into the SPJ
environment. To use jdbcMx.jar in a nonstandard location, set the UDR extensions
class path as you would on systems running G-series RVUs. For more information, see
Setting the JDBC/MX Location
on page 2-16.
Controlling JVM Startup Options
JVM startup options are passed to the Java application launcher (java) and influence
the Java run-time environment. To specify JVM startup options for an SPJ
environment, set the UDR_JAVA_OPTIONS default attribute. Use the
UDR_JAVA_OPTIONS default attribute to:
•
Override the NonStop Server for Java and JDBC/MX driver that are configured in
the Java environment.
•
Set class paths for an application that calls SPJs.
•
Set Java system properties for an application that calls SPJs.
•
Control the Java heap size of the SPJ environment.
•
Troubleshoot the SPJ environment.
This subsection covers these topics:
•
JVM Startup Options for All Processes on a Node on page 2-6
•
JVM Startup Options for Each SPJ Caller on page 2-7
•
Using Multiple UDR_JAVA_OPTIONS Settings in One Application on page 2-10
For more information about the UDR_JAVA_OPTIONS default attribute, see the
SQL/MX Reference Manual .
JVM Startup Options for All Processes on a Node
To set JVM startup options for all SPJ environments on a node, insert the
UDR_JAVA_OPTIONS default attribute as a row in the SYSTEM_DEFAULTS table:
SET SCHEMA NONSTOP_SQLMX_ node .SYSTEM_DEFAULTS_SCHEMA;
INSERT INTO SYSTEM_DEFAULTS
(ATTRIBUTE, ATTR_VALUE)