/** Generate query cache statistics for put, hit and miss count as one String */
public String generateQueryCacheStats(QueryStatistics stats) {
String result =
"(hitCount="
+ stats.getCacheHitCount()
+ ", missCount="
+ stats.getCacheMissCount()
+ ", putCount="
+ stats.getCachePutCount()
+ ").";
return result;
}
/**
* Performs 2 query calls, first call put query in the cache and second should hit the cache
*
* @param id Employee's id in the query
*/
public String queryCacheCheck(String id) {
EntityManager em = emf.createEntityManager();
Statistics stats = em.unwrap(Session.class).getSessionFactory().getStatistics();
stats.clear();
try {
// the nextTimestamp from infinispan is "return System.currentTimeMillis() / 100;"
Thread.sleep(1000);
String queryString = "from Employee e where e.id > " + id;
QueryStatistics queryStats = stats.getQueryStatistics(queryString);
Query query = em.createQuery(queryString);
query.setHint("org.hibernate.cacheable", true);
// query - this call should fill the cache
query.getResultList();
assertEquals(
"Expected 1 miss in cache" + generateQueryCacheStats(queryStats),
1,
queryStats.getCacheMissCount());
assertEquals(
"Expected 1 put in cache" + generateQueryCacheStats(queryStats),
1,
queryStats.getCachePutCount());
assertEquals(
"Expected no hits in cache" + generateQueryCacheStats(queryStats),
0,
queryStats.getCacheHitCount());
// query - second call should hit cache
query.getResultList();
assertEquals(
"Expected 1 hit in cache" + generateQueryCacheStats(queryStats),
1,
queryStats.getCacheHitCount());
} catch (AssertionError e) {
return e.getMessage();
} catch (InterruptedException e) {
return e.getMessage();
} finally {
em.close();
}
return "OK";
}