@Test public void testConnectionRollback() throws Exception { JdbcPooledConnectionSource pooled = new JdbcPooledConnectionSource(DEFAULT_DATABASE_URL); Dao<Foo, Integer> dao = null; DatabaseConnection conn = null; try { TableUtils.createTable(pooled, Foo.class); dao = DaoManager.createDao(pooled, Foo.class); conn = dao.startThreadConnection(); dao.setAutoCommit(conn, false); Foo foo = new Foo(); assertEquals(1, dao.create(foo)); assertNotNull(dao.queryForId(foo.id)); dao.endThreadConnection(conn); assertNull(dao.queryForId(foo.id)); } finally { TableUtils.dropTable(pooled, Foo.class, true); if (dao != null) { dao.endThreadConnection(conn); } pooled.close(); } }