DataSource dataSource = new ComboPooledDataSource(); dataSource.setMaxPoolSize(100); dataSource.setMinPoolSize(10); EntityEntityDao dao = new DefaultEntityEntityDao(); dao.setQueryResultCache(true); dao.setQueryResultCacheExpiration(3600); EntitySession session = new EntitySession(); session.setBatchMode(true); session.batchExecute("from User where age > ?", 18);