using a Java program on OS390 and DB2 version 7, we have the following
After creating a connection using "setAutoCommit(false)", we do some
updates on the database. If all updates have been done, a commit is
sent to the database. All this works well.
If we make the update on the database without sending a (manual)
commit to the database and closing our connection, the updates are
also commited even if we did not call "connection.commit()". We have
always thought that the database will do a rollback if the connection
will be closed without sending a commit, ...