//Build apply changes command
ApplyChangesCommand apply = Command.FACTORY.createApplyChangesCommand();
apply.setConnection(getConnection());
//Flush changes
apply.execute(root);
//Verify the change
root = select.executeQuery();
assertEquals("Pavick", getCustomerByLastName(root, "Pavick").getString("LASTNAME"));
assertEquals("NewCustomer", getCustomerByLastName(root, "NewCustomer").getString("LASTNAME"));