Caching Issue - Data not getting refreshed

[Himanshu]

Hi,
I have enabled second level query caching. Problem is when data is updated in the backend directly (not from UI), same is not reflected unless cache time expires. I have defined app-cache.xml like:

<cache
        name="org.hibernate.sample.model.LookupDO"
        maxElementsInMemory="5"
        eternal="false"
        overflowToDisk="true"
        timeToIdleSeconds="60"
        timeToLiveSeconds="60"/>

Even though time set is 60 seconds, no change is reflected before 120 seconds have elapsed (which is, I think, default value set in defaultCache).

Any suggestion to resolve issue is welcome.

[Subin Sugunan]

Set proper fetch policy.

[Himanshu]

Subin Sugunan wrote:Set proper fetch policy.

And what that would be?