The default autocommit mode depends on the data source to which the JDBC application connects.
For connections to DB2® data sources, the default autocommit mode is true.
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 |