On some database management systems, closing the cursor is sufficient to release a lock. Others, like ORACLE, require you to commit or rollback updates to release a lock. If your DBMS requires a commit or rollback, use the Auto commit setting.