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

Getting Started

HP NonStop SQL/MX Guide to Stored Procedures in Java—540433-003

2-3

Verifying the SQL/MX UDR Server

•

Verifying the SQL/MX UDR Server on page 2-3

•

Verifying the NonStop Server for Java on page 2-3

•

Verifying the JDBC/MX Driver on page 2-4

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:

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 Management Guide

for instructions about

installing the correct release of NonStop SQL/MX. For version compatibility, see

Tabl e 2- 1

on page 2-1.

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/java/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

VPROC - T9617H01 - (01 OCT 2004) SYSTEM \DRP24 Date 14 NOV 2005,

11:29:19

/G/SYSTEM/SYSTEM/MXUDR

Binder timestamp: 08NOV2005 17:41:27

Version procedure: T8432H01_01MAY2005_CCPLMAIN

Version procedure: T1230H22_06FEB2006_ACF_220_1103

Version procedure: T1231H22_06FEB2006_ACF_220_1103

Version procedure: T6520H02_01MAY2005_TFDS_SH_H02

Version procedure: T6520H02_01MAY2005_TFDSAPI_14JUN05_H02

TNS/E Native Mode: runnable file