MX 2.x)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

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.

jdbcmx.

enableLog

Enables logging of SQL statement IDs

and the corresponding JDBC SQL

statements. See enableLog Property.

Specifies the file to which the trace