private static void executeRequest(
ServerProxy server,
DataRequestExecutionResource drer)
throws Exception
{
CreateDataCache createCache = new CreateDataCache();
DeliverToRequestStatus deliver = new DeliverToRequestStatus();
deliver.connectInput(createCache.getResultOutput());
PipelineWorkflow workflow = new PipelineWorkflow();
workflow.add(createCache);
workflow.add(deliver);
executeWorkflow(drer, workflow);
ResourceID cacheID = createCache.nextResult();
String sql = "SELECT name, address FROM littleblackbook WHERE id=7958";
SQLQuery query = new SQLQuery();
query.addExpression(sql);
query.setResourceID("MySQLResource");