Autocommit

JDBC applications can use the autocommit property of a JDBC connection. The autocommit property causes a commit after each update to Db2®. When using type 2 connectivity, this commit is a CICS® commit, and results in the whole unit of work being committed.

Using the autocommit property also causes a commit to be taken when a connection is closed. The use of autocommit in with type 2 connectivity is not recommended. For this reason the IBM® Data Server Driver for JDBC and SQLJ sets a default of autocommit(false) when it runs in a CICS environment with type 2 connectivity. For type 4 connectivity the default is autocommit(true).