select.setParameterValue("accountNumber", account);
TypeHelper helper = TypeHelper.INSTANCE;
select.setDataObjectModel(helper.getType(DataGraphRoot.class));
DataGraphRoot root = (DataGraphRoot) select.executeQuery();
Collection accounts = root.getAccountSummaries();
AccountSummary accountData = (AccountSummary) accounts.iterator().next();
float newbalance = accountData.getBalance() + ammount;
accountData.setBalance(newbalance);
// update department set companyid = ? where department.name = ?
CommandGroup commandGroup = CommandGroup.FACTORY.createCommandGroup(createConfigStream());
commandGroup.setConnection(conn);
Command update = commandGroup.getCommand("update balance");
update.setParameterValue("BALANCE", new Float(newbalance));