SQL/MX Programming Manual for Java

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

About This Manual

This manual explains how to develop Java applications that contain embedded SQL

statements, otherwise known as SQLJ programs, for the NonStop SQL/MX

environment. SQLJ is defined in Part 10 of the ANSI/ISO/IEC 9075:2003 SQL standard

(SQL:2003), otherwise known as SQLJ Part 0. Use SQLJ to embed static SQL

statements in a Java program that accesses a database. In SQL/MX, an SQLJ

program uses embedded SQL/MX statements to access SQL/MP and SQL/MX

databases.

Throughout this manual, references to SQL/MX Release 2.x indicate SQL/MX Release

2.0, 2.1, and subsequent releases until otherwise indicated in a replacement

publication.

Audience

This manual is intended for application programmers who are embedding SQL

statements in a Java application. The reader should know:

•

The Java programming language

•

JDBC constructs and the HP NonStop JDBC Driver for SQL/MX (JDBC/MX)

•

Structured query language (SQL) and SQL/MX terms and concepts

Although not required, it helps to be familiar with the SQLJ standard, as described in

the International Standard Database Language SQL—Part 10: Object Language

Bindings (SQL/OLB) specification.

Organization

Note. HP NonStop SQL/MX SQLJ (product T1232) has reached MATURE support status,

meaning that requests for enhancements (RFEs) are not considered and that only critical

defects are repaired. To develop Java applications that access NonStop SQL/MP and SQL/MX

databases, use JDBC instead of SQLJ. For more information, see the JDBC Driver for

SQL/MX Programmer’s Reference.

Section 1, Introduction

Introduces SQLJ, explains the benefits of using

SQLJ, discusses SQLJ and JDBC

interoperability, and describes how an SQLJ

program is developed and executed.

Section 2, Getting Started

Describes the software requirements and system

configuration for developing and running

embedded SQL/MX programs in Java.

Section 3, SQLJ Programming

Describes how to embed SQL statements in a

Java program and covers basic SQLJ

programming constructs.