SQL/MX Programming Manual for Java

HP NonStop SQL/MX Programming Manual for Java—523726-003
2-1
2 Getting Started
Before you can develop and execute SQLJ programs in SQL/MX:
•
Verify that your system meets software requirements.
•
Install necessary software products.
•
Configure the Java environment for SQLJ programs.
This section covers these topics:
•
Software Requirements on page 2-1
•
Verifying Software Versions on page 2-2
•
Configuring the Java Environment on page 2-4
Software Requirements
To develop and execute SQLJ programs according to the instructions in this manual,
you must have SQL/MX Release 2.x installed on an HP NonStop system. For detailed
software requirements and installation instructions for SQL/MX, see the SQL/MX
Installation and Management Guide.
Table 2-1 shows the software products that you must install on a NonStop system to
develop and execute SQLJ programs.
SQLJ Product File
When you install SQL/MX, the installation automatically copies the SQLJ product file,
sqlj.jar, into the default location of /usr/tandem/sqlmx/lib. The sqlj.jar file
is a Java archive (JAR) file that contains the necessary components of the SQLJ
product, including the SQLJ translator and customizer. For SQL/MX installation
instructions, see the SQL/MX Installation and Management Guide.
Table 2-1. Software Products Required for SQLJ Programs
SQL/MX Product
Version
Minimum
Supported
RVU
NonStop Server for
Java
*
JDBC/MX Driver
*
SQL/MX Release 1.8 G06.18 T0083V31
(SDK 1.3.1_01)
T1225V20
SQL/MX Release 2.0 G06.23 T2766V10
(SDK 1.4.1)
T1225V31
SQL/MX Release 2.1 G06.23 T2766V10**
(SDK 1.4.1)
T1225V31**
*
The product numbers are minimum versions. SQL/MX supports later versions of the NonStop Server for Java
and JDBC/MX driver than the specified versions. See the README file on the NonStop Server for Java CD for
installation instructions and the latest version requirements.
**T1225V32, which must be used with T2766V20 (SDK 1.4.2), is recommended for improved performance of
dynamic SQL.