Spring data findone not fetching latest data

Question

I have spring data configured for my application where my DAO interface extends org.springframework.data.repository.CrudRepository to performer simple database operations. One of the DAO's findOne(id) method is not returning the latest record of a table even though my database has the latest data. It is always returning the old version of the record. There is no caching configured for the application. Is there any default JPA level caching which is preventing it to return the latest data?

EDIT: I am calling em.flush() after saving the record, so the subsequent call to findOne(id) must give me the latest record.

However, I see the one potential issue, my entire application is running in a clustered environment, so calling em.flush() might be refreshing the data only in one node where the data is being updated and all other nodes might still have the old data which may be causing the subsequent call to findOne(id) method is going through some other node where flush may not have happened yet. Is there a way to flush across nodes or is there any default timeout where the data gets refreshed automatically?

findOne() means find one document. It is not findLatest() – pvpkiran Mar 08 '18 at 10:30 — pvpkiran, Mar 08 '18 at 10:30
I am passing id of the document. – user1614862 Mar 08 '18 at 10:35 — user1614862, Mar 08 '18 at 10:35

score 0 · Answer 1 · answered Dec 27 '18 at 15:29

You can try disabling second level cache for hibernate. As you are using a clustered environment, when you create/update anything, as per my understanding it updates the cache for one cluster where the request went but not the other one. However, when you try to fetch the same record and when your request goes to the other cluster, it will give you the old record but not the latest one.

You can use the following configuration :

jpa:
  properties:
    hibernate:
      #################### HIBERNATE EHCACHE ####################
      #Disable second level cache for hibernate
      cache:
        use_second_level_cache: false
        auto_evict_collection_cache: false
        region:
          factory_class: org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory
        use_query_cache: true

Also, instead of using findOne() method, you should use findById() as in the 2.0 version, Spring-Data-JPA modified findOne() and now it returns an Optional. Which is not so bad to prevent NullPointerException.

See this for more info.

Correct me if I'm mistaken.

Spring data findone not fetching latest data

1 Answers1