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

18 Jun 2008


      Merci
Je suis en déplacement jusqu'a la fin de la semaine
Donc je ne peux pas tester sur le serveur de test  qui n'est vu quand 
interne
Je vous tiens au courant en début de semaine prochaine

Cordialement

Thierry

Arnaud Thimel a écrit :
...
Bonjour,
Je n'ai pas réussit à reproduire le bug.
Visiblement, il se comporte comme si l'utilisateur existait déjà en base...
Pouvez-vous tenter de refaire la manipulation et nous indiquer 
exactement à quelle étape l'erreur intervient et nous donner les 
paramètres saisis (nom d'utilisateur, email et isAdmin, isSuperAdmin si 
le premier écran ne lève pas d'erreur).
Merci.
Cordialement,
Arnaud.
thierry.faure a écrit :
...
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 mailing list
Simexplorer-si-devel at lists.labs.libre-entreprise.org
https://lists.labs.libre-entreprise.org/mailman/listinfo/simexplorer-si-deve...

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

thierry.faure＠cemagref.fr