Skip to Content
0
Apr 25, 2017 at 11:12 PM

How to invalidate a Query cache?

242 Views

Hi,

I have a number of web requests running at a time to access some DB values. Each transaction invokes the DB once and also updates the value.

All the requests are running almost in-parallel (though requests sent one by one, but processed very fast). I noticed that I was not getting the updated value from DB; means the query cache was not invalidated properly.

Is there a way to invalidate the query cache ; such that I could get the latest value which was recently updated by another request?

I see following statement which could be the root cause of my problem but I am looking for the solution :-( "There are circumstances where the invalidation is delayed, for example when working with transactions. By default, entries modified inside a transaction are invalidated after the transaction." https://wiki.hybris.com/display/release5/hybris+Platform+Cache

Thanks, Abhishek