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();
  }
  // for some reason, this passes on local machine, but fails in the build server
  public void XtestInitialLoad() throws Exception {
    session.save(new Simple(1, "test1"));
    session.save(new Simple(2, "test2"));
    session.save(new SimpleBase(1, "test1"));
    session.save(new SimpleExtend(2, "test2", "test2ex"));
    session.save(new SimpleBase(3, "test3"));

    DataIterator iterator = sqlDataProvider.initialLoad();
    int count = 0;
    while (iterator.hasNext()) {
      Object val = iterator.next();
      session.delete(val);
      count++;
    }
    assertEquals(5, count);
    List existing = session.createQuery("from java.lang.Object").list();
    assertEquals(0, existing.size());
  }
 protected void tearDown() throws Exception {
   deleteContent();
   sqlDataProvider.shutdown();
 }