JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2 (H06.25+, J06.14+)

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
This property is used to inherit the external applications transaction running on the NonStop system.
If the transaction exists, the database operation is performed within the specified transaction. If
the property is set and an external transaction does not exist or is not passed, you cannot perform
database-related operations. As a result, exceptions are generated.
The following is the exception:
Invaild/Nil transaction handle,useExternalTransaction property enabled
Set this property on a DataSource object, ConnectionPoolDataSource object, or a
DriverManager object.
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 (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.
user
The user property sets the Guardian user-name value for to MXCS. The Guardian user name
passed must have adequate access permissions for SQL/MX data accessed through MXCS.
Set this property on a DataSource object, ConnectionPoolDataSource object, or
DriverManager object.
Data type: String
Default: empty string
For example, user=NonStopSystem_username
52 Type 4 Driver Properties