Result sets and auto-commit Except for the result sets associated with holdable cursors, issuing a commit will cause all result sets on your connection to be closed. Result setsbehavior of with auto-commit

The JDBC application is not required to have auto-commit off when using update methods on updatable result set, even if the result set is not holdable. Positioned updates and deletes cannot be used in combination with autocommit and non-holdable result sets.