Connection conn = getConnection();
select.setConnection(conn);
select.setParameterValue("id", customerID);
TypeHelper helper = TypeHelper.INSTANCE;
select.setDataObjectModel(helper.getType(DataGraphRoot.class));
DataGraphRoot root = (DataGraphRoot) select.executeQuery();
accountReport.getAccountSummaries().addAll(root.getAccountSummaries());
// Get Stocks
select = Command.FACTORY.createCommand(
"SELECT Symbol, quantity, purchasePrice, purchaseDate, purchaseLotNumber FROM stocks where id = :id", createConfigStream());
select.setConnection(conn);
select.setParameterValue("id", customerID);
select.setDataObjectModel(helper.getType(DataGraphRoot.class));
// select.addConverter("STOCKS.PURCHASEDATE", DateConverter.class.getName());
root = (DataGraphRoot) select.executeQuery();
accountReport.getStockSummaries().addAll(root.getStockSummaries());
conn.close();
return accountReport;
} catch (Exception e) {