SQL/MX Programming Manual for Java

Getting Started

HP NonStop SQL/MX Programming Manual for Java—523726-003

2-2

NonStop Server for Java

To develop and execute SQLJ programs in 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 Environment Variable on page 2-4. For version

requirements, see Tabl e 2-1 on page 2-1.

JDBC/MX Driver

To develop and execute SQLJ programs in SQL/MX, you must install the JDBC/MX

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

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. For

version requirements, see Table 2-1 on page 2-1.

Verifying Software Versions

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

on a NonStop system:

•

Verifying the SQLJ Product on page 2-2

•

Verifying the NonStop Server for Java on page 2-3

•

Verifying the JDBC/MX Driver on page 2-3

Verifying the SQLJ Product

To display the product version of the SQLJ product (sqlj.jar), enter this java

command at an OSS prompt:

java -cp /usr/tandem/sqlmx/lib/sqlj.jar com.tandem.sqlj.vproc

The command displays output similar to:

Compare the output of the command with the product version in the T1232 SOFTDOC

file. If you have an incompatible product version of SQLJ on your system, see the

SQL/MX Installation and Management Guide for instructions on installing the correct

version of SQL/MX. For version compatibility, see Table 2-1 on page 2-1.

VPROC for Java : sqlj.jar T1232G10_29JAN2004_FCS_20040303