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();
}