JDBC Type 4 Driver 2.0 Programmer's Reference (SQL/MX 2.x)

java -Dt4sqlmx.properties=file_location ...
All the above said properties and configuration are applicable to the SQLMX XADataSource objects participating in
distributed transactions.
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.