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-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)