String tableName = getFreeTableName();
createMyTable(tableName);
dbAccessor.executeQuery("insert into " + tableName + "(id, name, time) values(1, 'Bob', 1234567)");
DatabaseSession databaseSession = dbAccessor.getNewDatabaseSession();
databaseSession.login();
Vector vector = databaseSession.executeSQL("select * from " + tableName + " where id=1");
assertEquals(vector.size(), 1);
Map map = (Map) vector.get(0);
//all names seem to be converted to upper case
assertEquals("Bob", map.get("name".toUpperCase()));