Added commit, rollback and secure functions.

Method to disable auto-commit, manually commit the changes based on
scenario and rollback changes if an error occur have been added.