auto commit added for dal