[Simexplorer-si-devel] Pb lors de la création d'un utilisateur

13 Jun 2008


      Bonjour j'ai une erreur l'ors de l'ajout d'un utilisateur Il me renvoie 
l'erreur une erreur (mais il le crée bien !!!)

A+

Thierry Faure


    Exception inconnue


    * org.apache.tapestry.runtime.ComponentEventException
      org.hibernate.exception.ConstraintViolationException: could not
      insert: [fr.cemagref.simexplorer.is.security.entities.User]

      context

      eventType
          action
      location
          context:UserEdit.tml, line 4, column 10
          1 	<t:layout
          xmlns:t="http://tapestry.apache.org/schema/tapestry_5_0_0.xsd"
          2 	title="${windowtitle}">
          3 	
          4 	<t:form>
          5 	<t:errors />
          6 	
          7 	<p>${message:simexplorer.ui.web.name} : <t:if test="creating">
          8 	<input t:type="TextField" t:id="login"
          9 	t:validate="required" t:value="user.login" size="40" />

    * org.apache.tapestry.runtime.ComponentEventException
      org.hibernate.exception.ConstraintViolationException: could not
      insert: [fr.cemagref.simexplorer.is.security.entities.User]

      context

      eventType
          success
      location
          context:UserEdit.tml, line 4, column 10

    * javax.ejb.EJBTransactionRolledbackException
      org.hibernate.exception.ConstraintViolationException: could not
      insert: [fr.cemagref.simexplorer.is.security.entities.User]

      causedByException
          javax.persistence.EntityExistsException:
          org.hibernate.exception.ConstraintViolationException: could
          not insert: [fr.cemagref.simexplorer.is.security.entities.User]

    * org.hibernate.exception.ConstraintViolationException
      could not insert: [fr.cemagref.simexplorer.is.security.entities.User]

      SQL
          insert into USERS (login, mail, passwordHash, admin,
          superAdmin, actorId) values (?, ?, ?, ?, ?, ?)
      SQLException
          org.h2.jdbc.JdbcSQLException: Unique index or primary key
          violation: CONSTRAINT_INDEX_4 ON PUBLIC.USERS(LOGIN) [23001-64]
      SQLState
          23001
      constraintName
          CONSTRAINT_INDEX_4 ON PUBLIC.USERS(LOGIN) [23001-64]
      errorCode
          23001
      messages
              o could not insert:
                [fr.cemagref.simexplorer.is.security.entities.User]
              o Unique index or primary key violation:
                CONSTRAINT_INDEX_4 ON PUBLIC.USERS(LOGIN) [23001-64]
      throwableCount
          2
      throwables
              o org.hibernate.exception.ConstraintViolationException:
                could not insert:
                [fr.cemagref.simexplorer.is.security.entities.User]
              o org.h2.jdbc.JdbcSQLException: Unique index or primary
                key violation: CONSTRAINT_INDEX_4 ON PUBLIC.USERS(LOGIN)
                [23001-64]

    * org.h2.jdbc.JdbcSQLException
      Unique index or primary key violation: CONSTRAINT_INDEX_4 ON
      PUBLIC.USERS(LOGIN) [23001-64]

      SQLState
          23001
      errorCode
          23001
      originalMessage
          Unique index or primary key violation: CONSTRAINT_INDEX_4 ON
          PUBLIC.USERS(LOGIN)
      Stack trace
              o org.h2.message.Message.getSQLException(Message.java:89)
              o org.h2.message.Message.getSQLException(Message.java:93)
              o org.h2.message.Message.getSQLException(Message.java:71)
              o org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:68)
              o org.h2.index.BtreeLeaf.add(BtreeLeaf.java:65)
              o org.h2.index.BtreeIndex.add(BtreeIndex.java:162)
              o org.h2.table.TableData.addRow(TableData.java:89)
              o org.h2.command.dml.Insert.update(Insert.java:88)
              o org.h2.command.CommandContainer.update(CommandContainer.java:68)
              o org.h2.command.Command.executeUpdate(Command.java:125)
              o org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:127)
              o org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:116)
              o org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
              o org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2250)
              o org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2640)
              o org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
              o org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
              o org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
              o org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
              o org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
              o org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:131)
              o org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:87)
              o org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:38)
              o org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:618)
              o org.hibernate.impl.SessionImpl.persist(SessionImpl.java:592)
              o org.hibernate.impl.SessionImpl.persist(SessionImpl.java:596)
              o org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:212)
              o org.jboss.ejb3.entity.TransactionScopedEntityManager.persist(TransactionScopedEntityManager.java:182)
              o fr.cemagref.simexplorer.is.security.dao.DaoActorImpl.saveActor(DaoActorImpl.java:173)
              o sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              o sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
              o sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              o java.lang.reflect.Method.invoke(Method.java:597)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
              o org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
              o org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
              o org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
              o org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:240)
              o org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:210)
              o org.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:84)
              o fr.cemagref.simexplorer.is.service.AuthenticationServiceImpl.saveUser(AuthenticationServiceImpl.java:491)
              o sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              o sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
              o sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              o java.lang.reflect.Method.invoke(Method.java:597)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
              o org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
              o org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
              o org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
              o org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:304)
              o org.jboss.ejb3.remoting.IsLocalInterceptor.invokeLocal(IsLocalInterceptor.java:81)
              o org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:72)
              o org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
              o org.jboss.ejb3.stateless.StatelessRemoteProxy.invoke(StatelessRemoteProxy.java:107)
              o fr.cemagref.simexplorer.is.ui.web.pages.UserEdit.onSuccess(UserEdit.java:154)
              o fr.cemagref.simexplorer.is.ui.web.pages.UserEdit.dispatchComponentEvent(UserEdit.java)
              o org.apache.tapestry.internal.structure.ComponentPageElementImpl.dispatchEvent(ComponentPageElementImpl.java:843)
              o org.apache.tapestry.internal.structure.ComponentPageElementImpl.triggerContextEvent(ComponentPageElementImpl.java:1004)
              o org.apache.tapestry.internal.structure.InternalComponentResourcesImpl.triggerContextEvent(InternalComponentResourcesImpl.java:178)
              o org.apache.tapestry.corelib.components.Form.onAction(Form.java:359)
              o org.apache.tapestry.corelib.components.Form.dispatchComponentEvent(Form.java)
              o org.apache.tapestry.internal.structure.ComponentPageElementImpl.dispatchEvent(ComponentPageElementImpl.java:851)
              o org.apache.tapestry.internal.structure.ComponentPageElementImpl.triggerContextEvent(ComponentPageElementImpl.java:1004)
              o org.apache.tapestry.internal.services.ComponentEventRequestHandlerImpl.handle(ComponentEventRequestHandlerImpl.java:67)
              o org.apache.tapestry.internal.services.ImmediateActionRenderResponseFilter.handle(ImmediateActionRenderResponseFilter.java:42)
              o org.apache.tapestry.internal.services.AjaxFilter.handle(AjaxFilter.java:42)
              o org.apache.tapestry.services.TapestryModule$40.handle(TapestryModule.java:2110)
              o org.apache.tapestry.internal.services.ComponentEventDispatcher.dispatch(ComponentEventDispatcher.java:135)
              o org.apache.tapestry.services.TapestryModule$13.service(TapestryModule.java:944)
              o org.apache.tapestry.internal.services.LocalizationFilter.service(LocalizationFilter.java:42)
              o org.apache.tapestry.services.TapestryModule$3.service(TapestryModule.java:553)
              o org.apache.tapestry.services.TapestryModule$2.service(TapestryModule.java:520)
              o org.apache.tapestry.internal.services.StaticFilesFilter.service(StaticFilesFilter.java:79)
              o org.apache.tapestry.internal.services.CheckForUpdatesFilter$2.invoke(CheckForUpdatesFilter.java:93)
              o org.apache.tapestry.internal.services.CheckForUpdatesFilter$2.invoke(CheckForUpdatesFilter.java:84)
              o org.apache.tapestry.ioc.internal.util.ConcurrentBarrier.withRead(ConcurrentBarrier.java:77)
              o org.apache.tapestry.internal.services.CheckForUpdatesFilter.service(CheckForUpdatesFilter.java:106)
              o org.apache.tapestry.services.TapestryModule$12.service(TapestryModule.java:924)
              o org.apache.tapestry.upload.internal.services.MultipartServletRequestFilter.service(MultipartServletRequestFilter.java:43)
              o org.apache.tapestry.internal.services.IgnoredPathsFilter.service(IgnoredPathsFilter.java:62)
              o org.apache.tapestry.TapestryFilter.doFilter(TapestryFilter.java:168)
              o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              o org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
              o org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
              o org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
              o org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
              o org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
              o org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
              o org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
              o org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
              o org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
              o org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
              o org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
              o org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
              o org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
              o org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
              o org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
              o java.lang.Thread.run(Thread.java:619)

[Simexplorer-si-devel] Pb lors de la création d'un utilisateur

thierry.faure＠cemagref.fr