Using JPA/Hibernate 3.2.2, not sure if this is a core or entitymanager question...

I can't seem to timeout my query cache. I have it enabled and it's working fine (DB backed resource bundle), but I was under the impression that a query like



Would reload the resource bundle data every 10 minutes. Now it never reloads and never pickes up the new resource bundle data. I'm using the HashtableCacheProvider (not that it should matter?).

Thanks in advance,
Nik

Hi there,

I think you might misunderstand the meaning of these properties. org.hibernate.cacheable determines whether the query is cacheable or not. That's fine. However, org.hibernate.timeout is a hint which determines the timeout of the SQL/JDBC query. It does not mean how long the query cache is valid.

Now, if you want to configure the cache timeout for your query cache you will have to configure the cache region org.hibernate.cache.QueryCache which is the default cache region when you don't specify a custom name. How the configuration looks like depends on your cache provider.

I am not so sure what you mean with 'pickes up the new resource bundle data'.

Cheers,
--Hardy

Aah, that explains it. Now I now where to start looking...



I was just referring to the desired behaviour that a value gets updated in the database (from an external source) and it would be picked up the next time the query cache would have been invalidated.