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

Introduction
HP NonStop SQL/MX Guide to Stored Procedures in Java—523727-004
1-14
SQL/MX UDR Server Process
•
The CALL statement has a UDR_JAVA_OPTIONS setting (other than ANYTHING)
that is the same as the UDR_JAVA_OPTIONS setting in one or more SPJ
environments that are servicing the application under the current user identity.
See Determining the Uniqueness of UDR_JAVA_OPTIONS Settings on page 2-15.
•
The CALL statement has a UDR_JAVA_OPTIONS setting of ANYTHING, and one
or more SPJ environments are currently servicing the application under the current
user identity.
Figure 1-5 shows how SQL/MX UDR server processes and SPJ environments are
initialized for an application.
Reinitialization of the SPJ Environment
In rare cases, the SQL/MX UDR server might crash unpredictably because of internal
system errors or the application code. In such cases, the SPJ environment is
reinitialized when a CALL statement is issued following the crash.
Figure 1-5. Initialization of SQL/MX UDR Server Processes
SQL/MX application named prog1
control query default UDR_JAVA_OPTIONS '-Da=1';
CALL proc_a();
control query default UDR_JAVA_OPTIONS '-Da=2';
CALL proc_b();
control query default UDR_JAVA_OPTIONS '-Da=1';
CALL proc_c();
control query default UDR_JAVA_OPTIONS '-Da=2';
CALL proc_d();
SQL/MX UDR
Server Process 1
SPJ Environment 1
SQL/MX UDR
Server Process 2
SPJ Environment 2
Identical JVM
Startup Options
and User Identity
Identical JVM
Startup Options
and User Identity
SQL/MX application named prog2
control query default UDR_JAVA_OPTIONS '-Da=1';
CALL proc_a();
control query default UDR_JAVA_OPTIONS '-Da=2';
CALL proc_b();
control query default UDR_JAVA_OPTIONS '-Da=1';
CALL proc_c();
control query default UDR_JAVA_OPTIONS '-Da=2';
CALL proc_d();
SQL/MX UDR
Server Process 3
SPJ Environment 3
SQL/MX UDR
Server Process 4
SPJ Environment 4
VST005.vsd
Identical JVM
Startup Options
and User Identity
Identical JVM
Startup Options
and User Identity