JDBC Type 4 Driver 3.0 Programmer's Reference (SQL/MX 3.x)

Connection by Using the DriverManager Class
Loading and Registering the Driver
Establishing the Connection
Guidelines for Connections Using the Driver Manager
The java.sql.DriverManager class is widely used to get a connection, but is less portable than the DataSource class.
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 finds a suitable driver that recognizes this URL and obtains a database connection using that driver.
com.tandem.t4jdbc.SQLMXDriver is the Type 4 driver class that implements the java.sql.Driver interface.
Loading and Registering the Driver
Before to the database, the application loads the Driver class and registers the Type 4 driver with the DriverManager
class in one of the following ways:
Specifies the Type 4 driver class in the -Djdbc.drivers option in the command line of the Java program:
-Djdbc.drivers=com.tandem.t4jdbc.SQLMXDriver
●
Uses the Class.forName method programmatically within the application:
Class.forName("com.tandem.t4jdbc.SQLMXDriver")
●
Adds the Type 4 driver class to the java.lang.System property jdbc.drivers property within the application:
jdbc.drivers=com.tandem.t4jdbc.SQLMXDriver
●
Establishing the Connection
The DriverManager.getConnection method accepts a string containing a Type 4 driver URL. The JDBC URL for the
Type 4 driver is:
jdbc:t4sqlmx://ip_address|machine_name:port_number/[:][property=value
[;property2=value2]...]
where
ip_address:port_number specifies the location where the NonStop MXCS association server is running.
property=value and property2=value2; specify a Type 4 driver property name-property value pair.
The pairs must be separated by a semicolon (;). For example,
T4LogLevel=ALL;T4LogFile=temp1.log
For information about the properties file, see Type 4 Driver Properties.
To establish a connection, the JDBC application can use the following code:
Class.forName("com.tandem.t4jdbc.SQLMXDriver"); //loads the driver
String url = “jdbc:t4sqlmx://ip_address|machine_name:port_number/”
Connection con = DriverManager.getConnection(url, “userID”, “Passwd”);
The variable con represents a connection to the MXCS data source that can be used to create and execute SQL statements.
Guidelines for Connections Using the Driver Manager
The Type 4 driver defines a set of properties that you can use to configure the driver. For detailed information about
these properties, see the Type 4 Driver Properties chapter.
●