SQL/MX 3.2.1 Guide to Stored Procedures in Java (H06.26+, J06.15+)

2 Getting Started
Before you can use SPJs in NonStop SQL/MX:
Verify that your system meets software requirements.
Install necessary software products.
Configure the SPJ environment.
This section covers these topics:
Software Requirements (page 32)
Verifying Software Versions (page 33)
Configuring the SPJ Environment on Systems Running H-Series RVUs (page 35)
Controlling JVM Startup Options (page 36)
Setting the JREHOME Location (page 40)
Setting the JDBC/MX Location (page 42)
Setting the Class Path (page 43)
Installing JAR Files in NonStop SQL/MX (page 46)
Establishing Java Security (page 46)
Software Requirements
To use SPJs according to the instructions in this manual, you must have NonStop SQL/MX Release
3.x installed on a NonStop system. For detailed software requirements and installation instructions
for NonStop SQL/MX, see the SQL/MX Installation and Upgrade Guide.
Table 1 lists the software products that you must install on a NonStop system to use SPJs in NonStop
SQL/MX and whether you must relink the SQL/MX UDR server (the MXUDR executable) after
installing those products.
Table 1 Software Products Required for SPJs
JDBC/MX Driver*NonStop Server for Java*Minimum Supported RVUSQL/MX Product Version
T1275H10 (equivalent to
T1225V32)
T006H10 (SDK 1.4.2)H06.03NonStop SQL/MX Release
2.0
T1275H10 (equivalent to
T1225V32)
T006H10 (SDK 1.4.2)H06.04NonStop SQL/MX Release
2.1
T1275H10 AAA (equivalent
to T1225V32)
T006H10 (SDK 1.4.2)H06.04NonStop SQL/MX Release
2.2
T1275H50 AAJT2766 H50 (SDK 1.5.0)H06.16NonStop SQL/MX Release
2.3
T1275H30T2766 H50/T2766 H60H06.22NonStop SQL/MX Release
3.0
T1275H31T2766 H50/T2766 H60H06.24NonStop SQL/MX Release
3.1
T1275H32T2766 H50/T2766 H60H06.25NonStop SQL/MX Release
3.2
T1275H32 AMUT2766 H70 (NSJ7)***H06.26NonStop SQL/MX Release
3.2.1**
*The product numbers are minimum versions on systems running H-series RVUs. See the README file on the NonStop
Server for Java CD for installation instructions and the latest version requirements.
32 Getting Started