Handling StaleObjectStateException?

[lcoetzee]

Hi
I am strugling to handle a org.hibernate.StaleObjectStateException.

My code to persist an entity is the following:

@IfInvalid(outcome = Outcome.REDISPLAY)
 public String save() {
 try {
 logger.info("Saving edited/created service.");
 service.setImage(new Date().toString());
 em.persist(service);
 em.flush();
 return "save";
 } catch (StaleObjectStateException e) {
 logger.error("Failed to persist service", e);
 FacesMessage facesMessage = new FacesMessage(e.getMessage());
 facesContext.addMessage(null, facesMessage);
 return null;

 }
 }

When simulating another user action on the entity (by changing the version value in the database) I can see that my application throws the Exception (and that it gets caught in my catch). Unfortunately I can't get JSF to redisplay with an error message.

My log file shows the following:

17:15:54,368 ERROR [ServiceManagementBean] Failed to persist service
org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [csir.structure.par.Service#5000]
 at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1635)
 at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2208)
 at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2118)
 at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2374)
 at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:84)
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
 at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
 at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1007)
 at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:196)
 at csir.structure.management.service.seam.ServiceManagementBean.save(ServiceManagementBean.java:122)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:109)
 at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:168)
 at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
 at org.jboss.seam.interceptors.ValidationInterceptor.validateTargetComponent(ValidationInterceptor.java:47)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.seam.util.Reflections.invoke(Reflections.java:13)
 at org.jboss.seam.interceptors.Interceptor.aroundInvoke(Interceptor.java:87)
 at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:60)
 at org.jboss.seam.interceptors.OutcomeInterceptor.interceptOutcome(OutcomeInterceptor.java:21)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.seam.util.Reflections.invoke(Reflections.java:13)
 at org.jboss.seam.interceptors.Interceptor.aroundInvoke(Interceptor.java:87)
 at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:60)
 at org.jboss.seam.interceptors.RollbackInterceptor.rollbackIfNecessary(RollbackInterceptor.java:30)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.seam.util.Reflections.invoke(Reflections.java:13)
 at org.jboss.seam.interceptors.Interceptor.aroundInvoke(Interceptor.java:87)
 at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:60)
 at org.jboss.seam.interceptors.BijectionInterceptor.bijectTargetComponent(BijectionInterceptor.java:32)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.seam.util.Reflections.invoke(Reflections.java:13)
 at org.jboss.seam.interceptors.Interceptor.aroundInvoke(Interceptor.java:87)
 at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:60)
 at org.jboss.seam.interceptors.ConversationInterceptor.endOrBeginLongRunningConversation(ConversationInterceptor.java:58)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.seam.util.Reflections.invoke(Reflections.java:13)
 at org.jboss.seam.interceptors.Interceptor.aroundInvoke(Interceptor.java:87)
 at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:60)
 at org.jboss.seam.interceptors.BusinessProcessInterceptor.manageBusinessProcessContext(BusinessProcessInterceptor.java:60)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.seam.util.Reflections.invoke(Reflections.java:13)
 at org.jboss.seam.interceptors.Interceptor.aroundInvoke(Interceptor.java:87)
 at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:60)
 at org.jboss.seam.interceptors.RemoveInterceptor.removeIfNecessary(RemoveInterceptor.java:37)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.seam.util.Reflections.invoke(Reflections.java:13)
 at org.jboss.seam.interceptors.Interceptor.aroundInvoke(Interceptor.java:87)
 at org.jboss.seam.interceptors.SeamInvocationContext.proceed(SeamInvocationContext.java:60)
 at org.jboss.seam.ejb.SeamInterceptor.aroundInvoke(SeamInterceptor.java:41)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:120)
 at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:62)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
 at org.jboss.ejb3.entity.ExtendedPersistenceContextPropagationInterceptor.invoke(ExtendedPersistenceContextPropagationInterceptor.java:57)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
 at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
 at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
 at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:196)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
 at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
 at org.jboss.ejb3.stateful.StatefulInstanceInterceptor.invoke(StatefulInstanceInterceptor.java:81)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
 at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
 at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
 at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:98)
 at org.jboss.ejb3.stateful.StatefulContainer.localInvoke(StatefulContainer.java:190)
 at org.jboss.ejb3.stateful.StatefulLocalProxy.invoke(StatefulLocalProxy.java:98)
 at $Proxy116.save(Unknown Source)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at com.sun.el.parser.AstValue.invoke(AstValue.java:151)
 at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:283)
 at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
 at com.sun.facelets.el.LegacyMethodBinding.invoke(LegacyMethodBinding.java:69)
 at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
 at javax.faces.component.UICommand.broadcast(UICommand.java:106)
 at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:90)
 at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:164)
 at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:316)
 at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
 at javax.faces.webapp.FacesServlet.service(FacesServlet.java:106)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:122)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.jboss.seam.servlet.SeamExceptionFilter.doFilter(SeamExceptionFilter.java:44)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
 at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:54)
 at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:174)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
 at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
 at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
 at java.lang.Thread.run(Thread.java:595)

followed by:

17:15:54,461 ERROR [SeamExceptionFilter] uncaught exception handled by Seam
javax.servlet.ServletException: Could not commit transaction
 at javax.faces.webapp.FacesServlet.service(FacesServlet.java:121)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:122)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.jboss.seam.servlet.SeamExceptionFilter.doFilter(SeamExceptionFilter.java:44)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
 at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:54)
 at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:174)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
 at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
 at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
 at java.lang.Thread.run(Thread.java:595)
17:15:54,467 ERROR [[Faces Servlet]] Servlet.service() for servlet Faces Servlet threw exception
java.lang.IllegalStateException: Could not commit transaction
 at org.jboss.seam.jsf.SeamExtendedManagedPersistencePhaseListener.commit(SeamExtendedManagedPersistencePhaseListener.java:74)
 at org.jboss.seam.jsf.SeamExtendedManagedPersistencePhaseListener.afterPhase(SeamExtendedManagedPersistencePhaseListener.java:44)
 at org.apache.myfaces.lifecycle.LifecycleImpl.informPhaseListenersAfter(LifecycleImpl.java:536)
 at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:318)
 at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
 at javax.faces.webapp.FacesServlet.service(FacesServlet.java:106)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:122)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.jboss.seam.servlet.SeamExceptionFilter.doFilter(SeamExceptionFilter.java:44)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
 at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:54)
 at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:174)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
 at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
 at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
 at java.lang.Thread.run(Thread.java:595)
Caused by: org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=ontheverge.icomtek.csir.co.za/25, BranchQual=, localId=25] status=STATUS_NO_TRANSACTION; - nested throwable: (org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [csir.structure.par.Service#5000])
 at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:369)
 at org.jboss.tm.TxManager.commit(TxManager.java:239)
 at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.commit(ServerVMClientUserTransaction.java:140)
 at org.jboss.seam.jsf.SeamExtendedManagedPersistencePhaseListener.commit(SeamExtendedManagedPersistencePhaseListener.java:68)
 ... 31 more
Caused by: org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [csir.structure.par.Service#5000]
 at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1635)
 at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2208)
 at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2118)
 at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2374)
 at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:84)
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
 at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
 at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1007)
 at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:354)
 at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:59)
 at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1488)
 at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1107)
 at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:321)
 ... 34 more

Any suggestions ?

Thanks

Louis

[robjellinghaus]

This is actually not really a Seam question, it's a question about optimistic concurrency in Hibernate.

In some sense, once you've gotten a StaleObjectStateException, it's too late. You have to throw out your whole Hibernate session, which is tough to do in general.

Here's a thread from the Hibernate forums about this exact issue, with some good ideas:

http://forum.hibernate.org/viewtopic.php?t=942461&highlight=retry

Cheers!
Rob

[lcoetzee]

Hi Rob,

thanks for the pointers but the issue is proving to be really troublesome. I do think this is something we need to resolve in every application that uses Seam (it does not appear to be handled in the examples). Or find a way to handle the exception gracefully in Seam. It has been discussed a bit in the EJB3 forums e.g.
http://www.jboss.com/index.html?module=bb&op=viewtopic&t=71611

I can define my own exception that can be thrown in my catch block (using the suggestions in the above thread), but who/what can catch that and handle it?

Still lost;-)

Louis

[gavin.king]

How I would probably try to solve this - and I have not had time to really sit down and think it through fully - is to have an interceptor wrapped around my EJB that knows how to catch the exception and forward to the appropriate recovery mechanism. This is always either:

(1) A page that tells the user "someone else updated this, go back to the start and try again"
(2) A page that tells that user "heres the data that you entered, heres the current data in the database, you need to merge those changes together" - and then this work needs to be done in a new PC and txn.

To "get" a new PC/txn to work with, call a session bean in the context of a REQUIRES_NEW transaction (if it is stateful, it needs to be a newly instantiated SFSB).

[lcoetzee]

Hi,

this is a first attempt (having never written interceptors or annotation before). Seems to work, but not ideal.

1. In my Interceptor I have no which interceptors need to be in Around and Within
2. Ideally I would like to add my annotation to the method and not the type, but for some reason I was unable to get that working
3. Ideally I would like to be able to specify the page where it should go. Right now it stays on the same page, requiring a cancel from the user.
4. Massive unknows about killing the transaction and clearing the entitymanager (I looked at Gavin's SeamExceptionFilter)

My annotation:

package csir.interceptor.seam;

import java.lang.annotation.ElementType;
import java.lang.annotation.Retention;
import java.lang.annotation.RetentionPolicy;
import java.lang.annotation.Target;

import javax.ejb.Interceptors;

@Target( { ElementType.TYPE })
@Retention(RetentionPolicy.RUNTIME)
@Interceptors(IfNAPExceptionInterceptor.class)
public @interface IfNAPException {
}

My interceptor

package csir.interceptor.seam;

import javax.ejb.AroundInvoke;
import javax.ejb.InvocationContext;
import javax.persistence.EntityManager;

import org.apache.log4j.Logger;
import org.jboss.seam.Component;
import org.jboss.seam.annotations.Around;
import org.jboss.seam.annotations.Within;
import org.jboss.seam.interceptors.BijectionInterceptor;
import org.jboss.seam.interceptors.BusinessProcessInterceptor;
import org.jboss.seam.interceptors.ConversationInterceptor;
import org.jboss.seam.interceptors.RemoveInterceptor;
import org.jboss.seam.interceptors.ValidationInterceptor;
import org.jboss.seam.util.Transactions;

import csir.common.seam.NAPException;

@Around( { BijectionInterceptor.class, ValidationInterceptor.class,
 ConversationInterceptor.class, BusinessProcessInterceptor.class })
@Within(RemoveInterceptor.class)
public class IfNAPExceptionInterceptor {

 static final Logger logger = Logger
 .getLogger(IfNAPExceptionInterceptor.class);

 @AroundInvoke
 public Object customInterceptor(InvocationContext ctx) throws Exception {
 logger.info("*** BEFORE INTERCEPTION ***");
 Object object = null;
 try {
 object = ctx.proceed();
 } catch (NAPException e) {
 EntityManager em = (EntityManager) Component.getInstance(
 "napEntityManager", false);
 logger.error("Got NAPException");
 rollbackAfterException();
 em.clear();
 }
 logger.info("*** AFTER INTERCEPTION ***");
 return object;
 }

 private void rollbackAfterException() {
 try {
 if (Transactions.isTransactionActiveOrMarkedRollback()) {
 logger.info("killing transaction");
 Transactions.getUserTransaction().rollback();
 }
 } catch (Exception te) {
 logger.error("could not roll back transaction", te);
 }
 }

}

as applied in the Stateful bean:

Stateful
@IfNAPException
@Name("serviceManagementBean")
@Interceptors(SeamInterceptor.class)
public class ServiceManagementBean implements Serializable, ServiceManagement {
.
.

and the method throwing the NAPException

@IfInvalid(outcome = Outcome.REDISPLAY)
 public String save() throws Exception {
 try {
 logger.info("Saving edited/created service.");
 em.persist(service);
 em.flush();
 return "save";
 } catch (StaleObjectStateException e) {
 logger.error("Failed to persist service", e);
 FacesMessage facesMessage = new FacesMessage(e.getMessage());
 facesContext.addMessage(null, facesMessage);
 throw new NAPException(e);
 }
 }

and finally the NAPException.

package csir.common.seam;

import java.io.Serializable;

import javax.ejb.ApplicationException;

@ApplicationException(rollback=true)
public class NAPException extends Exception implements Serializable {

 /**
 *
 */
 private static final long serialVersionUID = -5617117494284445988L;

 public NAPException() {
 super();
 }

 public NAPException(String message) {
 super(message);
 }

 public NAPException(String message, Throwable cause) {
 super(message, cause);
 }

 public NAPException(Throwable cause) {
 super(cause);
 }

}

I am sure this thing can be improved extensively.

Later

Louis

[gavin.king]

"lcoetzee" wrote:
2. Ideally I would like to add my annotation to the method and not the type, but for some reason I was unable to get that working

Seam does not yet support method-level interceptors. Look at the issues demo for how to work around that.

"lcoetzee" wrote:
3. Ideally I would like to be able to specify the page where it should go. Right now it stays on the same page, requiring a cancel from the user.

Look at the issues demo.

"lcoetzee" wrote:
4. Massive unknows about killing the transaction and clearing the entitymanager (I looked at Gavin's SeamExceptionFilter)

Hmmmm. Interesting. I should probably build some functionality like this into Seam. It is totally trivial for EJB3-container-managed PCs, but for Seam-managed PCs you'll need to do a little bit of work...