Hibernate clustering problem

[Adnan Badar]

Hi,

We are trying to implement Session Clustering using Spring & Hibernate deployed on Oracle10gAS 10.1.2.0.2. There are two OC4J servers configured for session clustering. On fail over request is successfully going to another one. For simple plain JSP application HTTP session build on first machine is available on second oc4j machine.

But session clustering is not working fine with application built using Hibernate and Spring. If both nodes are available then things work fine, when one node goes down then request goes to another server but hibernate pojo object are not in Synch (may be), or due to whatever reason we are getting below stack trace:

Exception while executing action
org.springframework.orm.hibernate3.HibernateOptimisticLockingFailureException:

Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect):
[FishingLicense#35965]; nested exception is org.hibernate.StaleObjectStateException:

Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [FishingLicense#35965]
org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [FishingLicense#35965]






Can any one provide me some hints regarding this issue?
[ May 13, 2007: Message edited by: Adnan Badar ]