Simexplorer-si-devel

Download

simexplorer-si-devel@list.forge.codelutin.com

July 2008

1 participants
1 discussions

Pb lors de la création d'un utilisateur
by thierry.faure＠cemagref.fr 29 Jul '08

29 Jul '08

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)

2 5