JDBC Driver for SQL/MP 3.0

Introduction to JDBC/MP Driver

The HP JDBC Driver for SQL/MP (JDBC/MP) implements the JDBC technology that conforms to the standard JDBC

3.0 Data Access API. This JDBC/MP driver enables Java applications to use HP NonStop SQL/MP to access NonStop

SQL databases.

For more information on the JDBC APIs associated with the JDBC/MP implementation, see Sun Microsystems

Documents. To obtain detailed information on the standard JDBC API, you should download the JDBC API

documentation provided by Sun Microsystems (http://java.sun.com/products/jdbc/download.html).

The JDBC/MP driver and HP NonStop Server for Java is a Java environment that supports compact, concurrent,

dynamic, portable programs for the enterprise server. The JDBC/MP driver requires NonStop Server for Java and

SQL/MP, which both require the HP NonStop Open System Services (OSS) environment. The NonStop Server for

Java uses the HP NonStop operating system to add the NonStop system fundamentals of scalability and program

persistence to the Java environment.

This section explains these subjects:

JDBC Driver Types

JDBC/MP Architecture

JDBC/MP API Packages

JDBC Driver Types

This table describes the types of JDBC drivers:

Type

Written

in Java

Description

No. Name

1 JDBC-to-

ODBC bridge

Possibly Uses a JDBC-to-ODBC bridge to translate JDBC calls to ODBC calls, which

are handled by an ODBC driver. This requires an ODBC driver on the client

side and an ODBC server on the server side.

2 Native protocol Partially Translates JDBC calls into the native API for a particular database. The driver

must run on a machine where this API is available. (sqlmp is a Type 2 driver.)

3 Pure Java Entirely Translates JDBC calls to a database-independent protocol for transmission over

the network. Server middleware then translates this protocol into a database's

native protocol.

4 Native protocol,

Pure Java

Entirely Translates JDBC calls directly to the network protocol of a particular database.

Thus, a JDBC program on the client can call directly to the database server.