JDBC Driver for SQL/MX Programmer's Reference

Home | Contents | Prev | Next | Index | Glossary
Accessing SQL Databases with
SQL/MX
This section describes the following subjects:
Connection to SQL/MX●
JDBC/MX Properties●
Transactions●
Stored Procedures●
SQL Context Management●
Nonblocking JDBC/MX●
Holdable Cursors●
Connection Pooling●
Statement Pooling●
Using Additional JDBC/MX Properties●
Supported Character Set Encodings●
Connection to SQL/MX
A Java application can obtain a JDBC connection to SQL/MX in two ways:
Using the DriverManager class●
Using the DataSource interface●
Connection Using the DriverManager Class
This is the traditional way to establish a connection to the database. The DriverManager class
works with the Driver interface to manage the set of drivers loaded. When an application issues a
request for a connection using the DriverManager.getConnection method and provides a
URL, the DriverManager is responsible for finding a suitable driver that recognizes this URL
and obtains a database connection using that driver.
com.tandem.sqlmx.SQLMXDriver is the JDBC/MX driver class that implements the
Driver interface. The application can load the JDBC/MX driver in one of the following ways,
except as noted in the DriverManager Object Properties table: