JDBC Driver for SQL/MP 3.0

Note: HP does not support third-party JDBC drivers for NonStop systems, but any JDBC driver that is
written entirely in Java (that is, a Type 3 or a Type 4 driver) can run on top of the NonStop Server for
Java. To use such a driver to connect your Java program to a third-party database, see the third-party
instructions for that driver.
JDBC/MP Architecture
The JDBC/MP driver is a Type 2 driver; it employs proprietary, native APIs to use SQL/MP to access NonStop SQL
databases. The native API of SQL/MP cannot be called from client systems. Therefore, the JDBC/MP driver runs on
NonStop servers only.
The JDBC/MP driver is best suited for a three-tier model. In the three-tier model, commands are sent to a middle tier
of services, which then sends the commands to the data source. The data source processes the commands and sends the
results back to the middle tier, which then sends the results to the user. This use of the middle tier
Allows you to maintain control over access and the kinds of updates that can be made to corporate data
Simplifies the deployment of applications
Can provide performance advantages
This figure illustrates a three-tier architecture for database access:
Architecture of the JDBC Driver for SQL/MP
JDBC/MP API Packages
The JDBC/MP API packages are shipped with the JDBC Driver for SQL/MP software.
The java.sql and javax.sql packages are included as part of Java 2, Standard Edition (J2SE) 1.4.1 and, therefore,