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

By default, this property is set true when a JDBC connection is established. If autoCommit
property is set to false, the current transaction remains active until the application explicitly
commits or rolls back the transaction. If the JDBC/MX Type 4 driver property
t4sqlmx.autoCommit is specified, and JDBC API method
java.sql.Connection.setAutoCommit() is called from the application, the values specified
in the API method take higher precedence over the property t4sqlmx.autoCommit.
Valid values: ON or OFF
Default value: ON
Data type: String
For example, -Dt4sqlmx.autoCommit = OFF
Example 1 Example for connection setting made through a DataSource or a
ConnectionPoolDataSource
SQLMXDataSource ds = new SQLMXDataSource();
ds.setAutoCommit("OFF");
try {
Connection Conn = ds.getConnection();
} catch (SQLException e) {
e.printStackTrace();
Example 2 Example for setting using a properties file
maxStatements=20
loginTimeout=15
initialPoolSize=10
connectionTimeout=10
serverDataSource=MXCS_server_data_source
autoCommit=OFF
Example 3 Example for setting using command line
-Dt4sqlmx.autCommit=OFF
Considerations:
When connection pooling is enabled, the driver applies the autoCommit setting on the connection
object before returning the object to the application.
Type 4 Driver Property Descriptions 53