MB-12754 Support auto-commit option

- If auto-commit option is enabled, user doesn't need to invoke
fdb_commit() manually.

- Manual fdb_commit() call is also allowed in auto-commit mode.

Change-Id: Ib8da9da487ece210f7bb0934f166631a9a4d81b6