[ 
https://issues.apache.org/jira/browse/DELTASPIKE-510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13879213#comment-13879213
 ] 

Jason Porter commented on DELTASPIKE-510:
-----------------------------------------

No problem, glad you found the issue!

> PersistenceException not handled by @Handles @FacesRequest 
> ExceptionEvent<javax.persistence.PersistenceException>
> -----------------------------------------------------------------------------------------------------------------
>
>                 Key: DELTASPIKE-510
>                 URL: https://issues.apache.org/jira/browse/DELTASPIKE-510
>             Project: DeltaSpike
>          Issue Type: Bug
>          Components: ExceptionControl-Module
>    Affects Versions: 0.5
>         Environment: JBoss AS 7.1
>            Reporter: Esteve
>              Labels: exception-handling
>
> Hi,
> I have defined a @ExceptionHandler  like this:
> @ExceptionHandler
> public class FacesExceptionHandler {
>       @Inject
>       private Logger log;
>       
>       public void handlePersistenceException(@Handles @FacesRequest 
> ExceptionEvent<javax.persistence.PersistenceException> evt, FacesContext 
> facesContext) {
>               log.debug( "JSF Exception handler.  Handling 
> javax.persistence.PersistenceException: ", evt);
>               facesContext.addMessage(null, new 
> FacesMessage(FacesMessage.SEVERITY_ERROR, "S'ha produït un error al 
> emmagatzemar les dades a la base de dades: 
> "+evt.getException().getLocalizedMessage() , ""));
>               evt.handledAndContinue();
>       }
>       public void handleOptimisticLockException(@Handles @FacesRequest 
> ExceptionEvent<OptimisticLockException> evt, FacesContext facesContext) {
>               log.debug( "JSF Exception handler.  Handling 
> OptimisticLockException: ", evt);
>               facesContext.addMessage(null, new 
> FacesMessage(FacesMessage.SEVERITY_ERROR, "El registre ha estat modificat a 
> la base de dades per un altre procés. Les dades no s'han guardat.", ""));
>               evt.handled();
>       }
>       public void showFacesMessage(@Handles @FacesRequest 
> ExceptionEvent<Throwable> evt, FacesContext facesContext) {
>               log.debug( "JSF Exception handler.  Handling Throwable: ", evt);
>               facesContext.addMessage(null, new 
> FacesMessage(FacesMessage.SEVERITY_ERROR, evt.getException().getMessage(), 
> ""));
>               evt.handledAndContinue();
>       }
>       
>       
> }
> But javax.persistence.PersistenceException is not handled:
> (http-localhost-127.0.0.1-8080-4) Error processing Update: : 
> javax.persistence.PersistenceException: 
> org.hibernate.exception.ConstraintViolationException: Unique index or primary 
> key violation: "CONSTRAINT_INDEX_4 ON 
> PUBLIC.UNITAT_NEGOCI_CANAL_VENDA(UNITAT_NEGOCI_ID, CANAL_VENDA_ID)"; SQL 
> statement:
> update UNITAT_NEGOCI_CANAL_VENDA set CODI_USUARI_ULTIMA_MODIFICACIO=?, 
> DATAHORA_CREACIO=?, DATAHORA_ULTIMA_MODIFICACIO=?, DATAHORA_ALTA=?, 
> DATAHORA_BAIXA=?, CANAL_VENDA_ID=?, UNITAT_NEGOCI_ID=?, VERSION=? where ID=? 
> and VERSION=? [23505-161]
>       at 
> org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1361)
>  [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1289)
>  [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1295)
>  [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:976)
>  [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.jboss.as.jpa.container.AbstractEntityManager.flush(AbstractEntityManager.java:439)
>  [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]
>       at 
> cat.tmb.tdo.ocicommerce.view.UnitatNegociCanalVendaBean.update(UnitatNegociCanalVendaBean.java:157)
>  [classes:]
>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
> [rt.jar:1.7.0_51]
>       at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
> [rt.jar:1.7.0_51]
>       at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>  [rt.jar:1.7.0_51]
>       at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
>       at 
> org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)
>  [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374)
>  [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:127)
>  [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:135)
>  [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)
>  [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
>  [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)
>  [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
>  [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.jpa.interceptor.SFSBInvocationInterceptor.processInvocation(SFSBInvocationInterceptor.java:58)
>  [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.ejb3.component.stateful.StatefulSessionSynchronizationInterceptor.processInvocation(StatefulSessionSynchronizationInterceptor.java:156)
>  [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:82)
>  [jboss-as-weld-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
>  [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
>  [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
>  [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.ejb3.component.stateful.StatefulComponentInstanceInterceptor.processInvocation(StatefulComponentInstanceInterceptor.java:66)
>  [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:228)
>  [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:304) 
> [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:190)
>  [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
>  [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)
>  [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
>  [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:32)
>  [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)
>  [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
>  [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165) 
> [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:173)
>  [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.ejb3.component.stateful.StatefulComponentIdInterceptor.processInvocation(StatefulComponentIdInterceptor.java:52)
>  [jboss-as-ejb3-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) 
> [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
>  [jboss-invocation-1.1.1.Final.jar:1.1.1.Final]
>       at 
> org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72)
>  [jboss-as-ee-7.1.1.Final.jar:7.1.1.Final]
>       at 
> cat.tmb.tdo.ocicommerce.view.UnitatNegociCanalVendaBean$$$view36.update(Unknown
>  Source) [classes:]
>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
> [rt.jar:1.7.0_51]
>       at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
> [rt.jar:1.7.0_51]
>       at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>  [rt.jar:1.7.0_51]
>       at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
>       at 
> org.jboss.weld.util.reflection.SecureReflections$13.work(SecureReflections.java:264)
>  [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]
>       at 
> org.jboss.weld.util.reflection.SecureReflectionAccess.run(SecureReflectionAccess.java:52)
>  [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]
>       at 
> org.jboss.weld.util.reflection.SecureReflectionAccess.runAsInvocation(SecureReflectionAccess.java:137)
>  [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]
>       at 
> org.jboss.weld.util.reflection.SecureReflections.invoke(SecureReflections.java:260)
>  [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]
>       at 
> org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:111)
>  [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]
>       at 
> org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)
>  [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]
>       at 
> org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:105)
>  [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]
>       at 
> cat.tmb.tdo.ocicommerce.view.UnitatNegociCanalVendaBean$Proxy$_$$_Weld$Proxy$.update(UnitatNegociCanalVendaBean$Proxy$_$$_Weld$Proxy$.java)
>  [classes:]
>       at 
> cat.tmb.tdo.ocicommerce.view.UnitatNegociCanalVendaBean$Proxy$_$$_WeldClientProxy.update(UnitatNegociCanalVendaBean$Proxy$_$$_WeldClientProxy.java)
>  [classes:]
>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
> [rt.jar:1.7.0_51]
>       at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
> [rt.jar:1.7.0_51]
>       at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>  [rt.jar:1.7.0_51]
>       at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
>       at org.apache.el.parser.AstValue.invoke(AstValue.java:262) 
> [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278) 
> [jbossweb-7.0.13.Final.jar:]
>       at 
> org.jboss.weld.util.el.ForwardingMethodExpression.invoke(ForwardingMethodExpression.java:39)
>  [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]
>       at 
> org.jboss.weld.el.WeldMethodExpression.invoke(WeldMethodExpression.java:50) 
> [weld-core-1.1.5.AS71.Final.jar:2012-02-10 15:31]
>       at 
> com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
>  [jsf-impl-2.1.7-jbossorg-2.jar:]
>       at 
> javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
>  [jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final]
>       at 
> com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
>  [jsf-impl-2.1.7-jbossorg-2.jar:]
>       at 
> org.apache.deltaspike.jsf.impl.config.view.ViewControllerActionListener.processAction(ViewControllerActionListener.java:63)
>  [deltaspike-jsf-module-impl-0.5.jar:0.5]
>       at 
> org.apache.deltaspike.jsf.impl.listener.action.DeltaSpikeActionListener.processAction(DeltaSpikeActionListener.java:51)
>  [deltaspike-jsf-module-impl-0.5.jar:0.5]
>       at javax.faces.component.UICommand.broadcast(UICommand.java:315) 
> [jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final]
>       at 
> javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794) 
> [jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final]
>       at 
> javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259) 
> [jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final]
>       at 
> com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
>  [jsf-impl-2.1.7-jbossorg-2.jar:]
>       at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) 
> [jsf-impl-2.1.7-jbossorg-2.jar:]
>       at 
> com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) 
> [jsf-impl-2.1.7-jbossorg-2.jar:]
>       at 
> org.apache.deltaspike.jsf.impl.listener.request.DeltaSpikeLifecycleWrapper.execute(DeltaSpikeLifecycleWrapper.java:75)
>  [deltaspike-jsf-module-impl-0.5.jar:0.5]
>       at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593) 
> [jboss-jsf-api_2.1_spec-2.0.1.Final.jar:2.0.1.Final]
>       at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.ocpsoft.rewrite.servlet.RewriteFilter.doFilter(RewriteFilter.java:205) 
> [rewrite-servlet-2.0.9.Final.jar:2.0.9.Final]
>       at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:840)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:622)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:560)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:488)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.ocpsoft.rewrite.servlet.impl.HttpRewriteResultHandler.handleResult(HttpRewriteResultHandler.java:38)
>  [rewrite-servlet-2.0.9.Final.jar:2.0.9.Final]
>       at 
> org.ocpsoft.rewrite.servlet.RewriteFilter.rewrite(RewriteFilter.java:268) 
> [rewrite-servlet-2.0.9.Final.jar:2.0.9.Final]
>       at 
> org.ocpsoft.rewrite.servlet.RewriteFilter.doFilter(RewriteFilter.java:188) 
> [rewrite-servlet-2.0.9.Final.jar:2.0.9.Final]
>       at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> cat.tmb.tdo.ocicommerce.view.filters.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:36)
>  [classes:]
>       at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> cat.tmb.tdo.ocicommerce.services.security.RoleBasedAuthorizationFilter.performAuthorizedRequest(RoleBasedAuthorizationFilter.java:97)
>  [classes:]
>       at 
> cat.tmb.tdo.ocicommerce.services.security.RoleBasedAuthorizationFilter.doFilter(RoleBasedAuthorizationFilter.java:80)
>  [classes:]
>       at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> com.codahale.metrics.servlet.AbstractInstrumentedFilter.doFilter(AbstractInstrumentedFilter.java:97)
>  [metrics-servlet-3.0.1.jar:3.0.1]
>       at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)
>  [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)
>  [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]
>       at 
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) 
> [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 
> [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) 
> [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) 
> [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)
>  [jbossweb-7.0.13.Final.jar:]
>       at 
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) 
> [jbossweb-7.0.13.Final.jar:]
>       at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
> Caused by: org.hibernate.exception.ConstraintViolationException: Unique index 
> or primary key violation: "CONSTRAINT_INDEX_4 ON 
> PUBLIC.UNITAT_NEGOCI_CANAL_VENDA(UNITAT_NEGOCI_ID, CANAL_VENDA_ID)"; SQL 
> statement:
> update UNITAT_NEGOCI_CANAL_VENDA set CODI_USUARI_ULTIMA_MODIFICACIO=?, 
> DATAHORA_CREACIO=?, DATAHORA_ULTIMA_MODIFICACIO=?, DATAHORA_ALTA=?, 
> DATAHORA_BAIXA=?, CANAL_VENDA_ID=?, UNITAT_NEGOCI_ID=?, VERSION=? where ID=? 
> and VERSION=? [23505-161]
>       at 
> org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:128)
>  [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
>  [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
>  [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
>  [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
>  [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
>  [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       at com.sun.proxy.$Proxy172.executeUpdate(Unknown Source)
>       at 
> org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3010)
>  [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2908)
>  [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3237)
>  [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:113)
>  [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:272) 
> [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:264) 
> [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:187) 
> [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326)
>  [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)
>  [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1081) 
> [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       at 
> org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:973)
>  [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]
>       ... 124 more
> Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key 
> violation: "CONSTRAINT_INDEX_4 ON 
> PUBLIC.UNITAT_NEGOCI_CANAL_VENDA(UNITAT_NEGOCI_ID, CANAL_VENDA_ID)"; SQL 
> statement:
> update UNITAT_NEGOCI_CANAL_VENDA set CODI_USUARI_ULTIMA_MODIFICACIO=?, 
> DATAHORA_CREACIO=?, DATAHORA_ULTIMA_MODIFICACIO=?, DATAHORA_ALTA=?, 
> DATAHORA_BAIXA=?, CANAL_VENDA_ID=?, UNITAT_NEGOCI_ID=?, VERSION=? where ID=? 
> and VERSION=? [23505-161]
>       at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
>       at org.h2.message.DbException.get(DbException.java:169)
>       at org.h2.message.DbException.get(DbException.java:146)
>       at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:81)
>       at org.h2.index.TreeIndex.add(TreeIndex.java:62)
>       at org.h2.table.RegularTable.addRow(RegularTable.java:121)
>       at org.h2.table.Table.updateRows(Table.java:439)
>       at org.h2.command.dml.Update.update(Update.java:128)
>       at org.h2.command.CommandContainer.update(CommandContainer.java:73)
>       at org.h2.command.Command.executeUpdate(Command.java:219)
>       at 
> org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143)
>       at 
> org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:129)
>       at 
> org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
>       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
> [rt.jar:1.7.0_51]
>       at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) 
> [rt.jar:1.7.0_51]
>       at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>  [rt.jar:1.7.0_51]
>       at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
>       at 
> org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
>  [hibernate-core-4.0.1.Final.jar:4.0.1.Final]
>       ... 137 more
> Thanks in advance.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Reply via email to