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?

Hi,
I have the same issue.
My architecture is as follows.
A Web cache acting as a Load balancer which distributes loads among 2 web caches (clustered) on their respective Linux machines. Then, the request from clustered web caches goes to HTTP servers which directly communicate with OC4J instance with session clustering enabled.
We deployed simple application on Oracle AS 10g 10.1.2.1.2 and tested by executing jsp code and saving the state in HTTP session. We shut down the server 1 and application state was still maintained.
But, if we run the above scenario with the Spring+Struts+Hibernate based J2EE application, objects in server 2 are not in synch with server 1 objects and threw an exception as
Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect)

Any solution/advice will be highly appreciated.
Thanks.

Taqi Hasan