public void XtestCountAndIterator() throws Exception { Transaction tx = session.beginTransaction(); session.save(new Simple(1, "test1")); session.save(new Simple(2, "test2")); tx.commit(); session.flush(); session.close(); SQLQuery<Simple> sql = new SQLQuery<Simple>(Simple.class, "id = ?"); sql.setParameter(1, 1); DataIterator it = sqlDataProvider.iterator(sql); assertTrue(it.hasNext()); assertEquals(1, ((Simple) it.next()).getId().intValue()); it.close(); sql.setParameter(1, 0); it = sqlDataProvider.iterator(sql); assertFalse(it.hasNext()); it.close(); }