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

results in an SQL exception. Therefore, do not specify
external
transactionMode under these conditions.
Considerations:
If any other string is specified for the value of transaction mode, mixed is used.
Using the external or mixed transaction mode can improve performance.
Using the internal transaction mode can affect performance for applications because of the overhead
of TMF transactions under a heavy load.
This property can be set within a JDBC/MX driver properties file, defined within a DataSource object,
or passed in through the
java command line.
The transaction mode can only be changed for new connections; therefore, it cannot be dynamically
changed within a connection.
This property can be specified in a data source, in the JDBC/MX properties file, or in the java command
line.
Setting Properties in the Command Line
JDBC/MX driver property names used on the command line in the java -D option must include the prefix:
jdbcmx.
This notation, which includes the period (.), ensures that all the JDBC/MX driver property names are unique
for a Java application. For example: the
maxStatements property becomes
jdbcmx.maxStatements
JDBC/MX Driver Properties Allowed in the Command Line
JDBC/MX Prefix Property Name Description
jdbcmx. contBatchOnError
Communicates with JDBC driver to
continue the remaining jobs in the
batch even after any
BatchUpdateExceptions. See
contBatchOnError Property.
jdbcmx. stmtatomicity
Allows the user to enable atomicity of
SQL statements at statement level.
See
stmtatomicity Property.
jdbcmx. batchBinding
Specifies that statements are batched
together in the
executeBatch()
operation. See Setting Batch
Processing for Prepared Statements.
jdbcmx. blobTableName
Specifies the LOB table for using BLOB
columns. See
LOB Table Name
Properties.
jdbcmx. catalog
Sets the default catalog. See Default
Catalog and Schema.
jdbcmx. clobTableName
Specifies the LOB table for using CLOB
columns. See
LOB Table Name
Properties.
Enables logging of SQL statement IDs