Esteve created DELTASPIKE-510:
---------------------------------

             Summary: 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


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