JDBC Driver for SQL/MX Programmer's Reference

jdbcmx. sqlmx_nowait
See Managing Nonblocking
JDBC/MX.
jdbcmx. traceFile
Specifies the trace file for
logging. See Enabling Tracing
for Application Servers.
jdbcmx. traceFlag
Sets the trace flag for logging.
See Enabling Tracing for
Application Servers.
jdbcmx. transactionMode
Sets the transaction mode,
which provides control over
how and when transactions are
performed. See
transactionMode
Property.
For example, using the mploc property in the OSS environment, specify the mploc property
including the prefix in either of the following forms:
-Djdbcmx.mploc=[\\node.]\$volume.subvolume
or
-Djdbcmx.mploc='[\node.]$volume.subvolume'
Transactions
The JDBC/MX driver provides transaction support to maintain data integrity and consistency. To
allow the application to interleave transactions between SQL/MX objects and the traditional file
system, the JDBC/MX driver checks if a transaction is active whenever it needs to interact with
SQL/MX.
When an active transaction exists, the autocommit setting is ignored, and the JDBC/MX driver
lets the application manage the transaction.
●
When no active transaction exists, the JDBC/MX driver manages the transactions.●
This implementation differs from JDBC/MP. In the JDBC/MP driver, two different types of URLs
decide which component manages the transaction.
If you are accessing BLOB and CLOB data, see also Transactions Involving Blob and Clob Access.