JDBC drivers for NonStop SQL database access

JDBC drivers implement JDBC API and provide access to NonStop SQL databases. You can use JDBC API calls in your Java programs to access SQL tables on NonStop systems. The following are the available drivers and the access they provide are:

• Type 2, which is native API driver to use in Java programs running with NSJ on a NonStop system. The type 2 driver is installed using SUT.

  • JDBC Driver for NonStop SQL/MX (JDBC/MX) for use with SQL/MX

  • JDBC Driver for NonStop SQL/MP (JDBC/MP) for use with SQL/MP

• JDBC Type 4, which uses network protocols built in the database engine. Type 4 driver communicates directly to the database using Java sockets. You can use the HPE NonStop JDBC Type 4 Driver in Java programs running on PCs, HP-UX systems, and other platforms for access to NonStop SQL/MX. For the latest list of supported platforms, see current JDBC Type 4 Softdoc, which can be found online by accessing Scout for NonStop Servers.

To obtain detailed information on the standard JDBC API, you can download the JDBC API documentation provided by Oracle documentation.

For information on HPE drivers that are provided to access SQL/MX or SQL/MP, see JDBC driver manuals at HPE Integrity NonStop Servers.