Which version of AppFuse are you using? Have you modified any of the user management code, e.g. UserDaoHibernate or UserManagerImpl?
Mike On 8/16/07, ujjala <[EMAIL PROTECTED]> wrote: > > > When i add a user which is already exist in database then it throws the > following exception. > org.hibernate.exception. I get the error also in jsp page. It does not > show > any message that user already exist. What is the reason please tell me. > > > > > > ConstraintViolationException: could not insert: [org.appfuse.model.User] > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java > :69) > at > org.hibernate.exception.JDBCExceptionHelper.convert( > JDBCExceptionHelper.java:43) > at > org.hibernate.persister.entity.AbstractEntityPersister.insert( > AbstractEntityPersister.java:2078) > at > org.hibernate.persister.entity.AbstractEntityPersister.insert( > AbstractEntityPersister.java:2427) > at > org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java > :51) > at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243) > at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java > :227) > at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java > :140) > at > org.hibernate.event.def.AbstractFlushingEventListener.performExecutions( > AbstractFlushingEventListener.java:296) > at > org.hibernate.event.def.DefaultFlushEventListener.onFlush( > DefaultFlushEventListener.java:27) > at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:980) > at > org.springframework.orm.hibernate3.HibernateTemplate$27.doInHibernate( > HibernateTemplate.java:788) > at > org.springframework.orm.hibernate3.HibernateTemplate.execute( > HibernateTemplate.java:365) > at > org.springframework.orm.hibernate3.HibernateTemplate.flush( > HibernateTemplate.java:786) > at > org.appfuse.dao.hibernate.UserDAOHibernate.saveUser(UserDAOHibernate.java > :56) > at > org.appfuse.service.impl.UserManagerImpl.saveUser(UserManagerImpl.java:56) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java > (Compiled > Code)) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java > (Compiled > Code)) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java(Compiled > Code)) > at java.lang.reflect.Method.invoke(Method.java(Compiled Code)) > at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection( > AopUtils.java:335) > at > > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint > (ReflectiveMethodInvocation.java:181) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( > ReflectiveMethodInvocation.java:148) > at > org.springframework.transaction.interceptor.TransactionInterceptor.invoke( > TransactionInterceptor.java:96) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( > ReflectiveMethodInvocation.java:170) > at > > org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke > (MethodBeforeAdviceInterceptor.java:53) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed( > ReflectiveMethodInvocation.java:170) > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke( > JdkDynamicAopProxy.java:176) > at $Proxy2.saveUser(Unknown Source) > at org.appfuse.webapp.action.UserAction.save(UserAction.java:265) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java > (Compiled > Code)) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java > (Compiled > Code)) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java(Compiled > Code)) > at java.lang.reflect.Method.invoke(Method.java(Compiled Code)) > at > org.apache.struts.actions.DispatchAction.dispatchMethod( > DispatchAction.java:274) > at org.appfuse.webapp.action.BaseAction.execute(BaseAction.java > :210) > at > org.apache.struts.action.RequestProcessor.processActionPerform( > RequestProcessor.java:419) > at > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java > :224) > at org.apache.struts.action.ActionServlet.process( > ActionServlet.java:1196) > at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java > :432) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at > com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService( > StrictServletInstance.java:110) > at > com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service( > StrictLifecycleServlet.java:174) > at > com.ibm.ws.webcontainer.servlet.IdleServletState.service( > StrictLifecycleServlet.java:313) > at > com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service( > StrictLifecycleServlet.java:116) > at > com.ibm.ws.webcontainer.servlet.ServletInstance.service( > ServletInstance.java:283) > at > com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch( > ValidServletReferenceState.java:42) > at > com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch( > ServletInstanceReference.java:40) > at > com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter( > WebAppFilterChain.java:76) > at > com.opensymphony.module.sitemesh.filter.PageFilter.parsePage( > PageFilter.java:118) > at > com.opensymphony.module.sitemesh.filter.PageFilter.doFilter( > PageFilter.java:52) > at > com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter( > FilterInstanceWrapper.java:132) > at > com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter( > WebAppFilterChain.java:71) > at > org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter( > UrlRewriteFilter.java:323) > at > com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter( > FilterInstanceWrapper.java:132) > at > com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter( > WebAppFilterChain.java:71) > at > org.appfuse.webapp.filter.GZIPFilter.doFilterInternal(GZIPFilter.java:42) > at > org.springframework.web.filter.OncePerRequestFilter.doFilter( > OncePerRequestFilter.java:76) > at > com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter( > FilterInstanceWrapper.java:132) > at > com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter( > WebAppFilterChain.java:71) > at > org.displaytag.filter.ResponseOverrideFilter.doFilter( > ResponseOverrideFilter.java:125) > at > com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter( > FilterInstanceWrapper.java:132) > at > com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter( > WebAppFilterChain.java:71) > at > org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal( > CharacterEncodingFilter.java:75) > at > org.springframework.web.filter.OncePerRequestFilter.doFilter( > OncePerRequestFilter.java:76) > at > com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter( > FilterInstanceWrapper.java:132) > at > com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter( > WebAppFilterChain.java:71) > at > com.opensymphony.clickstream.ClickstreamFilter.doFilter( > ClickstreamFilter.java:42) > at > com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter( > FilterInstanceWrapper.java:132) > at > com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter( > WebAppFilterChain.java:71) > at > > org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal > (OpenSessionInViewFilter.java:174) > at > org.springframework.web.filter.OncePerRequestFilter.doFilter( > OncePerRequestFilter.java:76) > at > com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter( > FilterInstanceWrapper.java:132) > at > com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter( > WebAppFilterChain.java:71) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:292) > at > org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke( > FilterSecurityInterceptor.java:108) > at > org.acegisecurity.intercept.web.SecurityEnforcementFilter.doFilter( > SecurityEnforcementFilter.java:197) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:303) > at > org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter( > AnonymousProcessingFilter.java:143) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:303) > at > org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter( > RememberMeProcessingFilter.java:154) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:303) > at > org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter > (SecurityContextHolderAwareRequestFilter.java:50) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:303) > at > org.acegisecurity.ui.AbstractProcessingFilter.doFilter( > AbstractProcessingFilter.java:246) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:303) > at > org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter( > HttpSessionContextIntegrationFilter.java:220) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > FilterChainProxy.java:303) > at > org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java > :173) > at > org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java > :120) > at > com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter( > FilterInstanceWrapper.java:132) > at > com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter( > WebAppFilterChain.java:71) > at > org.appfuse.webapp.filter.LocaleFilter.doFilterInternal(LocaleFilter.java > :49) > at > org.springframework.web.filter.OncePerRequestFilter.doFilter( > OncePerRequestFilter.java:76) > at > com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter( > FilterInstanceWrapper.java:132) > at > com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter( > WebAppFilterChain.java:71) > at > > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch > (WebAppRequestDispatcher.java:1010) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch( > WebAppRequestDispatcher.java:592) > at > com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward( > WebAppRequestDispatcher.java:204) > at > com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java > :125) > at > com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook( > WebAppInvoker.java:286) > at > com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation > (CachedInvocation.java:71) > at > com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI( > ServletRequestProcessor.java:182) > at > com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service( > OSEListener.java:334) > at > com.ibm.ws.webcontainer.http.HttpConnection.handleRequest( > HttpConnection.java:56) > at > com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java > :615) > at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439) > at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:912) > Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] > SQL0803N > One or more values in the INSERT statement, UPDATE statement, or foreign > key > update caused by a DELETE statement are not valid because the primary key, > unique constraint or unique index identified by "1" constrains table > "DB2ADMIN.USER" from having duplicate rows for those columns. > SQLSTATE=23505 > > at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException > (Unknown > Source) > at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException > (Unknown > Source) > at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code > (Unknown > Source) > at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(Unknown > Source) > at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeUpdate(Unknown > Source) > at > org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java > :23) > at > org.hibernate.persister.entity.AbstractEntityPersister.insert( > AbstractEntityPersister.java:2062) > -- > View this message in context: > http://www.nabble.com/Adding-same-user-tf4278429s2369.html#a12177826 > Sent from the AppFuse - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
