Hibernate disable Query Cache

Question

Following problem:

I create a Query to display all Entries of a MYSQL Table, if I edit a Field and execute the Query again I get the same (old) Result as in the first query.

It seems that Hibernate caches the Result. I tried to disable Caching with

query.setCachable(false)

"hibernate.cache.use_second_level_cache"

"cache.provider_class"

"org.hibernate.cacheable"

flushing and closing the session

but nothing works

I don't understand what you tried (it's pretty unclear to throw a bunch of options like you did). Also, I'd like to see the query. — Pascal Thivent
– Pascal Thivent, Commented Jun 24, 2010 at 13:25
It is a on a Servlet / JSP Page Query query = session.createQuery("from MyTable"); query.setCacheable(false); List<MyTable> bar = query.list(); on the first Call i get the Entries of the Table, then I edit manually some fields, if i call the function again (for example by refreshing/reloading) I get the same result as before — Patrick
– Patrick, Commented Jun 24, 2010 at 13:37
are you saving the object after changing it? Are there transactions involved? — matt b
– matt b, Commented Jun 24, 2010 at 13:43

matt b · Accepted Answer · 2010-06-24 13:19:01Z

4

I think the configuration you want is

hibernate.cache.use_query_cache = false

Reference.

answered Jun 24, 2010 at 13:19

matt b

140k66 gold badges287 silver badges352 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

matt b Over a year ago

this then implies that the query cache is not your problem at all

Peter Tillemans · Accepted Answer · 2010-06-24 13:22:00Z

2

Could it be that you never saved or updated the the changed entry to hibernate? When the cache returns the wrong result that is usually an indication something else is wrong.

answered Jun 24, 2010 at 13:22

Peter Tillemans

35.4k11 gold badges85 silver badges117 bronze badges

2 Comments

Patrick Over a year ago

I changed the field in the Table manually and i committed it too

Peter Tillemans Over a year ago

Can you update your question with the code, or at least the fragments relating to editing and updating the entry?

Saul Berardo · Accepted Answer · 2011-06-06 15:02:41Z

1

it has nothing to do with 2nd or Query caches, these are already disabled by default! What probably would help in your case is to call session.refresh(yourEntity) so that the state of your entity would be re-read by hibernate.

answered Jun 6, 2011 at 15:02

Saul Berardo

2,6103 gold badges21 silver badges25 bronze badges

Collectives™ on Stack Overflow

Hibernate disable Query Cache

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related