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-16
Using Multiple UDR_JAVA_OPTIONS Settings in
One Application
However, each of these UDR_JAVA_OPTIONS settings is different because of the
different order of the options:
CONTROL QUERY DEFAULT UDR_JAVA_OPTIONS
'-Xmx32M -Djava.class.path=/usr/otherclasses';
CALL...
CONTROL QUERY DEFAULT UDR_JAVA_OPTIONS
'-Djava.class.path=/usr/otherclasses -Xmx32M';
CALL...
These UDR_JAVA_OPTIONS settings are considered different because of differences
in white space:
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...
Performance Considerations of Using Multiple
UDR_JAVA_OPTIONS Settings
When an SQL/MX application executes CALL statements under different
UDR_JAVA_OPTIONS settings, multiple SQL/MX UDR server processes service the
application. NonStop SQL/MX maintains an SQL/MX UDR server process for each
different set of UDR_JAVA_OPTIONS in an application. Each SQL/MX UDR server
process contains its own embedded JVM.
For more information, see SQL/MX UDR Server Process on page 1-12.
Caution. The existence of multiple SQL/MX UDR server processes might significantly affect
system performance. Therefore, use UDR_JAVA_OPTIONS settings in your application only
when necessary.