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

Table 1 Software Products Required for SPJs (continued)

JDBC/MX Driver*NonStop Server for Java*Minimum Supported RVUSQL/MX Product Version

**Starting from NonStop SQL/MX Release 3.2.1, only NSJ7 or later versions of Java are supported.

***Distributed GC feature in NSJ7 is not supported for the SPJ.

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 (page 40). For version

requirements, see Table 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 (page 42). For version requirements, see Table 1.

Verifying Software Versions

Verify that you have compatible product versions of these necessary software products on a NonStop

system:

• Verifying the SQL/MX UDR Server (page 33)

• Verifying the NonStop Server for Java (page 34)

• Verifying the JDBC/MX Driver (page 34)

Verifying the SQL/MX UDR Server

To display the product version of the SQL/MX UDR server, enter this vproc command at an OSS

prompt:

vproc /G/system/system/mxudr

The command displays output similar to:

VPROC - T9617H01 - (01 FEB 2009) SYSTEM \YOSDEV1 Date 28 NOV 2012,

14:39:37

/G/system/system/mxudr

Binder timestamp: 26OCT2012 02:40:56

Version procedure: T6520H02_01MAY2005_TFDS_SH_H02

Version procedure: T1230H32_14FEB2013_APB_321_1025

Version procedure: T8432H04_17FEB2012_CCPLMAIN

Version procedure: T1231H32_14FEB2013_APB_321_1025

Version procedure: T6520H02_01MAY2005_TFDSAPI_14JUN05_H02

TNS/E Native Mode: runnable file

Compare the output of the command with the product version in the T1230 SOFTDOC file. If you

have an incompatible product version of the SQL/MX UDR server on your system, see the SQL/MX

Installation and Upgrade Guide for instructions about installing the correct release of NonStop

SQL/MX. For version compatibility, See Table 1 (page 32).

Verifying Software Versions 33