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

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

Getting Started

HP NonStop SQL/MX Guide to Stored Procedures in Java—523727-004

2-2

NonStop Server for Java

To create and execute SPJs in NonStop SQL/MX, you must install the NonStop Server

for Java on a NonStop system. Use the NonStop Server for Java to compile and

execute Java applications. For details about this product, see the NonStop Server for

Java Programmer’s Reference. For installation instructions, see the README file on

the product CD. If you install the NonStop Server for Java in a nonstandard location,

see Setting the JREHOME Location on page 2-17. For version requirements, see

Table 2-1.

JDBC/MX Driver

To create and execute SPJs in NonStop SQL/MX, you must install the JDBC/MX driver

on a NonStop system. The JDBC/MX driver enables a Java application to use NonStop

SQL/MX to access an SQL/MP or SQL/MX database. For details about this product,

see the JDBC Driver for SQL/MX Programmer’s Reference. For installation

instructions, see the README file on the NonStop Server for Java product CD. If you

install the JDBC/MX driver in a nonstandard location, see Setting the JDBC/MX

Location on page 2-20. For version requirements, see Table 2-1.

Using SPJ-Incompatible Versions in the Java Environment

On systems running G-series RVUs, SPJs in NonStop SQL/MX require specific

product versions of the NonStop Server for Java and JDBC/MX driver to be installed.

However, other Java applications on the same system might require product versions

of the NonStop Server for Java and JDBC/MX driver that are incompatible with SPJs.

To use SPJs when the Java environment is configured with versions of the NonStop

Server for Java and JDBC/MX driver that are incompatible with SPJs, follow the

instructions in Support Note S04147.

Table 2-1. Software Products Required for SPJs

SQL/MX Product

Version

Minimum

Supported

RVU

NonStop Server

for Java

JDBC/MX

Driver

Relinking

MXUDR

Required?

NonStop SQL/MX

Release 1.8

G06.18 T0083V31

(SDK 1.3.1_01)

T1225V20 Yes

NonStop SQL/MX

Release 2.0

G06.23 T2766V10

(SDK 1.4.1)

T1225V31 Yes

NonStop SQL/MX

Release 2.1

G06.23 T2766V10

(SDK 1.4.1)

T1225V31 Yes

The product numbers are required versions on systems running G-series RVUs. See the README file on the

NonStop Server for Java CD for installation instructions and the latest version requirements. To use other

versions of the NonStop Server for Java and the JDBC/MX driver, see Using SPJ-Incompatible Versions in the

Java Environment on page 2-2.