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

HP NonStop SQL/MX Guide to Stored Procedures in Java540433-003
2-1
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 on page 2-1
Verifying Software Versions on page 2-2
Configuring the SPJ Environment on Systems Running H-Series RVUs on
page 2-5
Controlling JVM Startup Options on page 2-6
Setting the JREHOME Location on page 2-13
Setting the JDBC/MX Location on page 2-16
Setting the Class Path on page 2-18
Installing JAR Files in NonStop SQL/MX on page 2-21
Establishing Java Security on page 2-22
Software Requirements
To use SPJs according to the instructions in this manual, you must have NonStop
SQL/MX Release 2.x installed on a NonStop system. For detailed software
requirements and installation instructions for NonStop SQL/MX, see the
SQL/MX
Installation and Management Guide
.
Tabl e 2- 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 2-1. Software Products Required for SPJs (page 1 of 2)
SQL/MX Product
Version
Minimum
Supported
RVU
NonStop Server
for Java
*
JDBC/MX
Driver
*
Relinking
MXUDR
Required?
NonStop SQL/MX
Release 2.0
H06.03 T006H10
(SDK 1.4.2)
T1275H10
(equivalent to
T1225V32)
No
*
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.