calling Connection.rollback() rather than Statement.cancel() to rollback
the changes