Result Sets and Autocommit

Issuing a commit causes all result sets on your connection to be closed.

A JDBC application is not required to have autocommit off when using update methods on an updatable result set. However, positioned updates and deletes cannot be used in combination with autocommit.