// must ensure the right SQLTemplateAction is created
DbAdapter adapter = getAccessStackAdapter().getAdapter();
SQLAction plan = adapter.getAction(template, getNode());
assertTrue(plan instanceof SQLTemplateAction);
MockOperationObserver observer = new MockOperationObserver();
Connection c = getConnection();
try {
plan.performAction(c, observer);
}
finally {
c.close();
}
List rows = observer.rowsForQuery(template);
assertNotNull(rows);
assertEquals(1, rows.size());
Map row = (Map) rows.get(0);
// In the absence of ObjEntity most DB's return a Long here, except for Oracle