JDBC Driver for SQL/MX Programmer's Reference

Home | Contents | Prev | Next | Index | Glossary | Prev | Next
Introduction to JDBC/MX Driver
The HP JDBC Driver for SQL/MX (JDBC/MX) implements the JDBC technology that
conforms to the standard JDBC 3.0 Data Access API. This JDBC/MX driver enables Java
applications to use HP NonStop SQL/MX to access NonStop SQL databases.
For more information on the JDBC APIs associated with the JDBC/MX implementation, see
Sun Microsystems Documents earlier in this document. 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/MX driver together with HP NonStop Server for Java 4 is a Java environment that
supports compact, concurrent, dynamic, portable programs for the enterprise server. The
JDBC/MX driver requires NonStop Server for Java 4 and SQL/MX, which both require the HP
NonStop Open System Services (OSS) environment. The NonStop Server for Java 4 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/MX Architecture●
JDBC API Packages●
Sample Programs Summary●
JDBC/MX Architecture
The JDBC/MX driver is a Type 2 driver; it employs proprietary native APIs to use SQL/MX to
access NonStop SQL databases. The native API of SQL/MX cannot be called from client
systems. For this reason, the JDBC/MX driver runs on NonStop servers only.
The JDBC/MX 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 them to the user. The middle tier makes it possible to maintain control over access and the
kinds of updates that can be made to corporate data. Another advantage is that it simplifies the
deployment of applications. Finally, in many cases, the three-tier architecture can provide
performance advantages.