JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2.1 (H06.26+, J06.15+)
Table 1 Document Structure
DescriptionChapter
Describes the JDBC/MX driver architecture and the API package.“Introduction to JDBC/MX Driver” (page 15)
Describes where to find information about the installation requirements
and explains how to verify the JDBC/MX driver installation.
“Installing and Verifying JDBC/MX” (page 17)
Explains how to access SQL databases with SQL/MX from the NonStop
Server for Java 4 by using the JDBC/MX driver.
“Accessing SQL Databases with SQL/MX”
(page 21)
Describes working with BLOB and CLOB data in JDBC applications using
the standard interface described in the JDBC 3.0 API specification.
“Working with BLOB and CLOB Data”
(page 44)
Describes the database management (administrative) tasks for adding
and managing the tables for BLOB and CLOB data. The JDBC/MX driver
“Managing the SQL/MX Tables for BLOB and
CLOB Data” (page 54)
uses SQL/MX tables in implementing support for BLOB and CLOB data
access.
Describes the Module File Caching (MFC) feature of the JDBC/ MX T2
Driver.
“Module File Caching” (page 58)
Explains how JDBC/MX differs from the Oracle JDBC standard because
of limitations of SQL/MX and the JDBC/MX driver.
“JDBC/MX Compliance” (page 62)
Explains how to use the JDBC trace facility and how to log SQL statement
IDs and corresponding JDBC SQL statements.
“JDBC Trace Facility” (page 74)
Lists messages in numerical SQLCODE order. The descriptions include
the SQLCODE, SQLSTATE, message-text, the cause, the effect, and
recovery information.
“Messages” (page 80)
Shows sample program accessing CLOB and BLOB data.“Sample Programs Accessing CLOB and BLOB
Data” (page 96)
Defines many terms that this document uses.“Glossary” (page 100)
Related documentation
For background information about the features described in this guide, see the following documents:
• HP NonStop JDBC/MX Driver for NonStop SQL/MX API Reference (javadoc information about
the JDBC/MX APIs available in the NonStop Technical Library at Business Support Center
(BSC))
• “NonStop System computing documents” (page 8)
• “Oracle documents” (page 10)
NonStop System computing documents
The following NonStop system computing documents are available in the HP NonStop Technical
Library at Business Support Center (BSC).
• Introductory guides
Describes differences between NonStop SQL/MP and NonStop SQL/MX
databases.
SQL/MX Comparison Guide for
SQL/MP Users
Describes basic techniques for using SQL in the SQL/MX conversational interface
(MXCI). Includes information about installing the sample database.
SQL/MX Quick Start Guide
8










