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

On systems running H-series RVUs, notice that the NonStop Server for Java and JDBC/MX driver

are not bound into the SQL/MX UDR server.

Verifying the NonStop Server for Java

To display the product version of the NonStop Server for Java in the Java environment of a NonStop

system, enter this vproc command at an OSS prompt:

vproc /usr/tandem/nssjava/jdk170_h70/bin/java

If you have set the JREHOME environment variable for a nonstandard location of the NonStop

Server for Java, enter:

vproc $JREHOME/../bin/java

The command displays output similar to:

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

14:47:37

/usr/tandem/nssjava/jdk170_h70/bin/java

Binder timestamp: 23OCT2012 20:04:54

Version procedure: T2766H70_17FEB2013_jdk170_23Oct2012

Version procedure: T8432H04_17FEB2012_CCPLMAIN

TNS/E Native Mode: runnable file

Look for the product number of the JDK in the displayed output to determine the product version

of the NonStop Server for Java that is installed on the system in the specified location.

Compare the output of the command with the product version in the README or SOFTDOC file of

the NonStop Server for Java. If you have an incompatible product version of the NonStop Server

for Java, obtain the correct version of the product and follow the installation instructions in the

README file on the product CD. See also.

For version compatibility, See Table 1 (page 32)

Verifying the JDBC/MX Driver

To display the product version of the JDBC/MX driver in the Java environment of a NonStop system,

enter this java command at an OSS prompt:

java -cp /usr/tandem/jdbcMx/current/lib/jdbcMx.jar JdbcMx

-version

The -cp option specifies the class path of the JDBC/MX driver, which, in this example, represents

the standard location of the JDBC/MX driver. The location (standard or nonstandard) of the

JDBC/MX driver must be specified in either the -cp option or the CLASSPATH environment variable.

If you have already set the class path of the JDBC/MX driver in the session, enter:

java JdbcMx -version

The command displays output similar to:

HP JDBC driver for NonStop(TM) SQL/MX Version T1275R32_20FEB2013_JDBCMXAMU_1029

The JDBCMX information indicates the product version of the JDBC/MX driver that is installed on

the system in the specified location.

Compare the output of the command with the product version in the README or SOFTDOC file of

the JDBC/MX driver. If you have an incompatible product version of JDBC/MX, obtain the correct

version of the product and follow the installation instructions in the README file on the NonStop

Server for Java product CD.

For version compatibility, See Table 1 (page 32)

34 Getting Started