Hibernate 5二级缓存不工作，仍在从数据库中获取

Question

Am计划用Hibernate 5实现二级缓存。实体类用@Cacheable注释，并添加了CacheConcurrentStrategy.READ_WRITE策略。但它仍然在数据库中查找数据，而不是缓存。日志显示2个SQL查询。

请参阅我的主要方法

public static void main(String[] args) {
HolidayDAOImpl holidayImpl = new HolidayDAOImpl();
holidayImpl.setSessionFactory(HibernateUtil.INSTANCE.getSessionFactoryInstance());
holidayImpl.load().forEach(System.out :: println);
System.out.println("Loading second time");
holidayImpl.load().forEach(System.out::println);
}   

请参阅Hibernate Util枚举

public enum HibernateUtil{
INSTANCE;
public SessionFactory getSessionFactoryInstance(){  
Properties properties = new Properties();
properties.setProperty(Environment.URL, "jdbc:mysql://dummy");
properties.setProperty(Environment.DIALECT, "org.hibernate.dialect.MySQLDialect");
properties.setProperty(Environment.DRIVER, "com.mysql.jdbc.Driver");
properties.setProperty(Environment.USER, "demo");
properties.setProperty(Environment.PASS, "demo");
//second level cache prop
properties.setProperty(Environment.USE_SECOND_LEVEL_CACHE, "true");
properties.setProperty(Environment.USE_QUERY_CACHE, "true");
properties.setProperty(Environment.CACHE_REGION_FACTORY, "org.hibernate.cache.ehcache.EhCacheRegionFactory");
//logging
properties.setProperty("hibernate.show_sql","true");
properties.setProperty("hibernate.format_sql","true");
Configuration cfg = new Configuration();
cfg.setProperties(properties);
cfg.addAnnotatedClass(Holidays.class);
StandardServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder().applySettings(cfg.getProperties()).build();
SessionFactory sessionFactory = cfg.buildSessionFactory(serviceRegistry);
return sessionFactory;
}
}

请参阅DAOImpl类

public List<Holidays> load() {
try (Session session = sessionFactory.openSession()) {
//List<Holidays> result = session.createQuery("from Holidays", Holidays.class).getResultList();
Criteria criteria  = session.createCriteria(Holidays.class);
criteria.add(Restrictions.like("holiday_name", "%QA%"));
return criteria.list();
} catch (Exception e) {
e.printStackTrace();
}
return null;
}

pom.xml

<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.13</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-core -->
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>5.4.1.Final</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-ehcache</artifactId>
<version>5.4.1.Final</version>
</dependency>
</dependencies>

在浏览一些堆栈溢出的答案时，可以理解在最新版本的Hibernate(版本4之后)中，配置有一些更改。不确定我在配置上犯了什么错误。

请有人调查一下，弄清楚为什么它仍然在寻找数据库而不是缓存？

Answer 1

若要使用hibernate查询缓存，必须在每个查询中添加setCacheable (true)。

如果将criteria.setCacheable (true);添加到DAOImpl类，则第二个查询结果来自缓存。