@Test
public void testRetrieveMessageId() throws Exception {
generateTestData();
ConnectionsSmsHandler handler = new ConnectionsSmsHandler();
handler.setSqlEngine(new DerbyEngine(dataSource));
MessageCriteria criteria = new MessageCriteria()
.addProperty("smsc_messageid", "8");
Collection<Message> messages = handler.listMessages(connection, criteria);