JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

the URL is:
jdbc:t4sqlmx//ip_address|machine_name:port_number/[:]
[property=value[;property2=value]...]
where ip_address|machine_name:port_number specifies the location where the MXCS association server is running.
Data type: String
Default: none
For example:
url=jdbc:t4sqlmx://mynode.mycompanynetwork.net:18000/
url Property Considerations
If the url parameter is not specified and DriverManager.getConnection() is called, the Type 4 driver throws an SQLException.
If you use a literal IPV4 or IPV6 address in a URL, note the following guidelines:
For IPV6 only, enclose the address in brackets ([ and ]).
The port number is optional according to both the IPV4 and IPV6 standard.
The default port number for the MXCS association server is 18650.
useArrayBinding Property
useArrayBinding property improves the performance of the SELECT and INSERT statements.
When this property is set to “true”, the JDBC T4 driver sends/receives multiple rows to/from the MXOSRVR, which in turn
sends/receives information about multiple rows to/from SQL/MX.
This property is ideal for bulk SELECT and INSERT operations.
useArrayBinding property has no influence on UPDATE and DELETE statements.
This property
accepts only the following values:
true
false
Data Type:
String
Default: false
For example,
specify the value true as
useArrayBinding = true
useExternalTransaction Property
This property is used to inherit the external applications transaction running on the NonStop. If the transaction exists, the database operation is
performed within the specified transaction. If the transaction does not exist, the database operation is performed with SQL/MX transaction.
Set this property on a DataSource object, ConnectionPoolDataSource object, or a DriverManager object. For information on how to set
properties, see
How to Specify JDBC Type 4 Properties.
Data type: String
Default Value: NO
Values: NO or YES
For example:
useExternalTransaction = YES
Considerations:
This feature is supported only when the client side JVM (loading the Type 4 driver) is running on the NonStop platform (that is, when the Type
4 driver is used instead of the Type 2 driver).
This feature requires NS Java 1.6, SPR T2766^ACA or later.
Java.sql.connection.setAutoCommit(), Java.sql.connection.commit(), and Java.sql.connection.rollback() methods are NO-OP when
this property is enabled.
BLOB, CLOB, and XA features are not supported when this property is enabled.
executeBatchWithRowsAffected
is not supported.