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.