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

Getting Started
HP NonStop SQL/MX Guide to Stored Procedures in Java—523727-004
2-15
Using Multiple UDR_JAVA_OPTIONS Settings in
One Application
--- SQL operation complete.
>>CONTROL QUERY DEFAULT UDR_JAVA_OPTIONS RESET;
--- SQL operation complete.
For more information about MXCI, see the SQL/MX Reference Manual.
Displaying the UDR_JAVA_OPTIONS in Effect for an MXCI
Session
To show the UDR_JAVA_OPTIONS setting in effect for a CONTROL QUERY
DEFAULT statement issued in MXCI, enter the SHOWCONTROL command in the
current MXCI session. For more information about SHOWCONTROL, see the SQL/MX
Reference Manual.
Using Multiple UDR_JAVA_OPTIONS Settings in One Application
In the same application, you can set multiple UDR_JAVA_OPTIONS, each of which
controls the JVM startup options in an SPJ environment. Two or more
UDR_JAVA_OPTIONS settings are considered different or identical, depending on how
you specify them in CONTROL QUERY DEFAULT statements. See Determining the
Uniqueness of UDR_JAVA_OPTIONS Settings on page 2-15.
If you specify different UDR_JAVA_OPTIONS settings in the same application, be
aware of the Performance Considerations of Using Multiple UDR_JAVA_OPTIONS
Settings on page 2-16.
Determining the Uniqueness of UDR_JAVA_OPTIONS
Settings
Two or more UDR_JAVA_OPTIONS settings are considered to be different when their
character string literals do not match during a case-sensitive string comparison. The
case, white space, and order in which the options appear within each character string
literal must be the same for UDR_JAVA_OPTIONS settings to be considered identical.
For example, these UDR_JAVA_OPTIONS settings in separate CONTROL QUERY
DEFAULT statements are considered to be the same:
CONTROL QUERY DEFAULT UDR_JAVA_OPTIONS
'-Xmx32M -Djava.class.path=/usr/otherclasses';
CALL...
CONTROL QUERY DEFAULT UDR_JAVA_OPTIONS
'-Xmx32M -Djava.class.path=/usr/otherclasses';
CALL...