newCust.set("ID", new Integer(100));
newCust.set("ADDRESS", "5528 Wells Fargo Drive");
// Purposely do not set lastname to let it default to 'Garfugengheist'
// newCust.set("LASTNAME", "Gerkin" );
ApplyChangesCommand apply = Command.FACTORY.createApplyChangesCommand();
apply.setConnection(getConnection());
apply.execute(root);
Command readNewCust = Command.FACTORY.createCommand("select * from CUSTOMER where ID = 100");
readNewCust.setConnection(getConnection());
root = readNewCust.executeQuery();