Hibernate Second Level Cache Always Call Database on fetch All entities

Question

I enabled hibernate 2nd level caching in my sprint boot 2.1.8 application by adding the following configuration:

spring.jpa.properties.hibernate.cache.use_second_level_cache=true
spring.jpa.properties.hibernate.cache.region.factory_class=org.hibernate.cache.ehcache.EhCacheRegionFactory

I also added eh cache dependancy as follows:

     <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-ehcache</artifactId>
        <version>5.3.11.Final</version>
    </dependency>

I annotated an entity to be cacheable:

@Entity(name = "entity")
@Cacheable
@org.hibernate.annotations.Cache(usage = CacheConcurrencyStrategy.READ_WRITE)
@Table(name = "entity")
@AttributeOverride(name = "id", column = @Column(name = "entity_id"))

    public class Entity extends ItemBase {
        private String n1;
        private String n2;
        private String n3;
        private int n4;
        @Column(name = "n_5")
        private int n5;
  //getters and setters
        }

Each time i call the repository class (Which extends JpaCrudRepository) and call findAll(); or findOneById(), i see hibernate log HQL queries and database is actually called.

The desired behavior is to fetch the list of entities once from database and keep them in cache, where they should be updated there using read write strategy.

Any idea how can this be acheived?

You can refer this link. https://stackoverflow.com/questions/31585698/spring-boot-jpa2-hibernate-enable-second-level-cache — Sambit, Oct 07 '19 at 14:26
I implemented the suggested solution there, but it didnt work as well. — Marwan Tushyeh, Oct 07 '19 at 14:56
Don't put `@Cacheable` on the Entity. You have to annotate `@Cacheable` to method returning value. — Anish B., Oct 07 '19 at 16:13
I am trying to implement Hibernate 2nd level caching. i think you are referring to Spring cache abstraction. — Marwan Tushyeh, Oct 07 '19 at 16:23
@jumping_monkey it turns out by definition, hibernate always reaches the DB in case of select *, it then takes the pk from the query and retrieve the objects from the cache — Marwan Tushyeh, Feb 01 '21 at 21:50

Hibernate Second Level Cache Always Call Database on fetch All entities

0 Answers0