JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

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
autoCommit
The autoCommit property specifies whether SQL/MX automatically commits or rolls back if an
error occurs at the end of a statement execution. This property applies to any statement for which
the system initiates a transaction. If this property is set to true, SQL/MX automatically commits
any changes or rolls back any changes made to the database at the end of a statement execution.
52 Type 4 Driver Properties