Holdable cursors and autocommit

When autocommit is on, positioned updates and deletes are not supported for ResultSet objects that hold cursors open. If you attempt an update or delete, an exception is thrown.

Related reference
Non-holdable cursor example