record.setId7(new Integer(777777));
record.setSecondFirstName("bammbamm2");
record.setThirdFirstName("bammbamm3");
dao.insert(record);
AwfulTableExample example = new AwfulTableExample();
example.or().andFirstFirstNameLike("b%").andId2EqualTo(new Integer(222222));
example.or().andFirstFirstNameLike("wi%");
example.setOrderByClause("\"A_CuStOmEr iD\"");
List answer = dao.selectByExample(example);
assertEquals(2, answer.size());
AwfulTable returnedRecord = (AwfulTable) answer.get(0);
assertEquals(11, returnedRecord.getId1().intValue());
assertEquals(22, returnedRecord.getId2().intValue());