ResultSets and auto-commit

Except for the result sets associated with holdable cursors (see Holdable cursors for more information), issuing a commit will cause all result sets on your connection to be closed.

The JDBC program is not required to have auto-commit off when using updatable ResultSets.

Related concepts
Updatable cursors
Scrolling insensitive ResultSets
Related reference
Simple non-updatable ResultSets
Holdable cursors