Fix error handling for commit errors and raise rollback exception

Fix error handling for commit errors and raise rollback exception #54