added transactions for mysqli db-adapter