Updated all services to use PDO transactions for graceful failing