SQL exception causes Hibernate second level cache to have stale data with Infinispan as the provider

Question

We are using Infinispan (clustered using JGroups) as our second level cache in our JPA(Hibernate) based application. When a database operation fails, we see that the level-2 cache is stale. For example:

1) Attempt to create a user with login "joe." 2) Call persist(user); 3) persist fails due to database uniqueness constraint. 4) Do a find by id on login=joe (assuming login is the PK). 5) Hibernate returns joe user from Infinispan cache, even though database doesn't have it.

Configuring XA transactions and have Infinispan participate in XA seems like overkill in this situation. Is XA the only way to address this?

To close the loop on this, I had to enable XA (using Atomikos) to make keep the cache in sync. Manik's solution didn't work. — Καrτhικ, Dec 16 '11 at 20:54

score 2 · Answer 1 · answered Aug 24 '11 at 09:09

2

Enable transaction synchronization, much cheaper than XA.

See http://infinispan.blogspot.com/2011/06/faster-infinispan-based-second-level.html for more details.

answered Aug 24 '11 at 09:09

Manik Surtani

396
3
12

Also see https://docs.jboss.org/author/display/ISPN/Using+Infinispan+as+JPA-Hibernate+Second+Level+Cache+Provider – Manik Surtani Aug 24 '11 at 09:16

score 0 · Accepted Answer · answered Jul 31 '12 at 19:58

0

I had to enable XA transactions by deploying Atomikos to keep the cache in sync. Other solutions did not work.

answered Jul 31 '12 at 19:58

Καrτhικ

3,833
2
29
42

SQL exception causes Hibernate second level cache to have stale data with Infinispan as the provider

2 Answers2