NonStop Server for Java (NSJ) Programmer's Guide (NSJ 2.1+)

| Contents | Index | Glossary | Prev | Next
Accessing NonStop SQL/MP Databases
Java programs interact with NonStop SQL/MP databases using the Java Database Connectivity (JDBC) API.
The NonStop Server for Java...based on Java 2 Platform, Standard Edition, SDK 1.2.2 (short form: NonStop Java) and the
JDBC Driver for SQL/MP include the following items:
The JDBC 2.0 API●
The JDBC DriverManager in the Java Development Kit (JDK) 1.2.2●
The following Type 2 drivers, which behave identically except where stated otherwise:
The standard driver, sqlmp, which manages transactions as described in the JDBC API documentation provided
by Sun Microsystems
❍
The transaction-aware driver, sqlmptx, which allows you to define transactions outside of JDBC by using the
methods described in Transactions
❍
●
To connect a Java program to an SQL/MP database, you must use the JDBC DriverManager to load a driver, and then use
that driver to connect the program to the database.
This section describes the following subjects:
JDBC Driver for SQL/MP Support for JDBC●
Transactions and JDBC●
SQL/MP Driver Requirements●
JDBC Driver Types●
JDBC DriverManager●
Loading a Driver●
Connecting a Program to a Database●
Passing SQL/MP Statements to a Database●
Compatible Java and SQL/MP Data Types●
Referring to Database Objects●
Troubleshooting●
Sample SQL/MP Program●
Compliance Information●
JDBC Driver for SQL/MP Support for JDBC 2.0●
SQL/MP Support for JDBC
The SQL/MP drivers support the following subset of the JDBC API:
Exceptions
BatchUpdateException❍
SQLException❍
SQLWarning❍
The following methods are inherited from SQLException:
getErrorCode❍
getNextException❍
●