Default JDBC autocommit modes
The default autocommit mode depends on the data source to which the JDBC application connects.
Autocommit default for Db2 data sources
For connections to Db2 data sources,
the default autocommit mode is true
.
Autocommit default for IBM Informix data sources
For connections to IBM® Informix® data sources, the default autocommit mode depends on the type of data source. The following table shows the defaults.
Type of data source | Default autocommit mode for local transactions | Default autocommit mode for global transactions |
---|---|---|
ANSI-compliant database | true | false |
Non-ANSI-compliant database without logging | false | not applicable |
Non-ANSI-compliant database with logging | true | false |