Tip: Use Auto commit
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.
Last modified date: 01/29/2015