Yes, I can see from the view source the userId value="7" and the version value="0". BTW, this stacktrace happens as a result of editing newly created users. In case I try to edit one of the 2 users (user and admin) shipped with AppFuse, there is no stacktrace. It is very strange!
--Irshad. mraible wrote: > > If you view-source when you're editing the user, are the userId and > version property stored as hidden fields? > > Matt > > On Mon, Aug 18, 2008 at 3:53 AM, Irshad Buchh <[EMAIL PROTECTED]> wrote: >> >> Hi Matt, >> No, I created a user userid=ibuchh with [EMAIL PROTECTED], no >> problem >> at all. Next I try to edit this user itself, that is where the stack >> trace >> results. I have mentioned the steps to reproduce this as well. >> >> --Irshad. >> >> >> mraible wrote: >>> >>> Are you using a username or e-mail address that already exists? >>> >>> On Sun, Aug 17, 2008 at 12:21 PM, Irshad Buchh <[EMAIL PROTECTED]> wrote: >>>> >>>> 1. Create a JSF 2.0.2 project .... success >>>> 2. Run mvn jetty:run-war .... success >>>> 3. Log in to the app http://localhost:8080 ...success >>>> 4. Create a new user ...success >>>> 5. Edit the newly created user ....failure below is the stack trace >>>> >>>> Please help, are we missing here something. >>>> >>>> --Irshad. >>>> ================STACK TRACE==================== >>>> >>>> DEBUG [btpool0-1] UserDaoHibernate.saveUser(47) | user's id: null >>>> Hibernate: insert into app_user (id, account_expired, account_locked, >>>> address, city, country, postal_code, province, credentials_expired, >>>> email, >>>> account_enabled, first_name, last_name, password, password_hint, >>>> phone_number, username, version, website) values (null, ?, ?, ?, ?, ?, >>>> ?, >>>> ?, >>>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) >>>> WARN [btpool0-1] JDBCExceptionReporter.logExceptions(77) | SQL Error: >>>> -104, >>>> SQLState: 23000 >>>> ERROR [btpool0-1] JDBCExceptionReporter.logExceptions(78) | Unique >>>> constraint violation: SYS_CT_222 in statement [insert into app_user >>>> (id, >>>> account_expired, account_locked, address, city, country, postal_code, >>>> province, credentials_expired, email, account_enabled, first_name, >>>> last_name, password, password_hint, phone_number, username, version, >>>> website) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >>>> org.springframework.dao.DataIntegrityViolationException: could not >>>> insert: >>>> [edu.ksu.model.User]; nested exception is >>>> org.hibernate.exception.ConstraintViolationException: could not insert: >>>> [edu.ksu.model.User] >>>> at >>>> org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:624) >>>> at >>>> org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) >>>> at >>>> org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424) >>>> at >>>> org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) >>>> at >>>> org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:744) >>>> at >>>> edu.ksu.dao.hibernate.UserDaoHibernate.saveUser(UserDaoHibernate.java:48) >>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>> at >>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>>> at >>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>>> at java.lang.reflect.Method.invoke(Method.java:597) >>>> at >>>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310) >>>> at >>>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) >>>> at $Proxy39.saveUser(Unknown Source) >>>> at >>>> edu.ksu.service.impl.UserManagerImpl.saveUser(UserManagerImpl.java:101) >>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>> at >>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>>> at >>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>>> at java.lang.reflect.Method.invoke(Method.java:597) >>>> at >>>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310) >>>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) >>>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) >>>> at >>>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) >>>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >>>> at >>>> org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:50) >>>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >>>> at >>>> org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50) >>>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >>>> at >>>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) >>>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >>>> at >>>> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) >>>> at >>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) >>>> at >>>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) >>>> at $Proxy43.saveUser(Unknown Source) >>>> at edu.ksu.webapp.action.UserForm.save(UserForm.java:135) >>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>> at >>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>>> at >>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>>> at java.lang.reflect.Method.invoke(Method.java:597) >>>> at com.sun.el.parser.AstValue.invoke(AstValue.java:187) >>>> at >>>> com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297) >>>> at >>>> com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68) >>>> at >>>> javax.faces.component._MethodExpressionToMethodBinding.invoke(_MethodExpressionToMethodBinding.java:75) >>>> at >>>> org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:54) >>>> at javax.faces.component.UICommand.broadcast(UICommand.java:121) >>>> at >>>> org.ajax4jsf.framework.ajax.AjaxViewRoot.processEvents(AjaxViewRoot.java:274) >>>> at >>>> org.ajax4jsf.framework.ajax.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:250) >>>> at >>>> org.ajax4jsf.framework.ajax.AjaxViewRoot.processApplication(AjaxViewRoot.java:405) >>>> at >>>> org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32) >>>> at >>>> org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:103) >>>> at >>>> org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:76) >>>> at >>>> javax.faces.webapp.FacesServlet.service(FacesServlet.java:148) >>>> at >>>> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487) >>>> at >>>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093) >>>> at >>>> org.ajax4jsf.framework.ajax.xmlfilter.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:75) >>>> at >>>> org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:213) >>>> at >>>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >>>> at >>>> org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:147) >>>> at >>>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >>>> at >>>> edu.ksu.webapp.filter.MessageFilter.doFilter(MessageFilter.java:46) >>>> at >>>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >>>> at >>>> com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) >>>> at >>>> com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) >>>> at >>>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >>>> at >>>> org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:164) >>>> at >>>> org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141) >>>> at >>>> org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90) >>>> at >>>> org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:406) >>>> at >>>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >>>> at >>>> net.sf.ehcache.constructs.web.filter.GzipFilter.doFilter(GzipFilter.java:75) >>>> at >>>> net.sf.ehcache.constructs.web.filter.Filter.doFilter(Filter.java:92) >>>> at >>>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >>>> at >>>> edu.ksu.webapp.filter.LocaleFilter.doFilterInternal(LocaleFilter.java:74) >>>> at >>>> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) >>>> at >>>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >>>> at >>>> com.opensymphony.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:42) >>>> at >>>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >>>> at >>>> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:359) >>>> at >>>> org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) >>>> at >>>> org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) >>>> at >>>> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >>>> at >>>> org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) >>>> at >>>> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >>>> at >>>> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >>>> at >>>> org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) >>>> at >>>> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >>>> at >>>> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >>>> at >>>> org.springframework.security.ui.rememberme.RememberMeProcessingFilter.doFilterHttp(RememberMeProcessingFilter.java:116) >>>> at >>>> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >>>> at >>>> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >>>> at >>>> org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91) >>>> at >>>> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >>>> at >>>> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >>>> at >>>> org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:172) >>>> at >>>> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >>>> at >>>> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >>>> at >>>> org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:268) >>>> at >>>> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >>>> at >>>> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >>>> at >>>> org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:87) >>>> at >>>> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >>>> at >>>> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >>>> at >>>> org.springframework.security.ui.SessionFixationProtectionFilter.doFilterHttp(SessionFixationProtectionFilter.java:61) >>>> at >>>> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >>>> at >>>> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >>>> at >>>> org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) >>>> at >>>> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) >>>> at >>>> org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:371) >>>> at >>>> org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:174) >>>> at >>>> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) >>>> at >>>> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) >>>> at >>>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >>>> at >>>> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96) >>>> at >>>> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) >>>> at >>>> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) >>>> at >>>> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360) >>>> at >>>> org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) >>>> at >>>> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) >>>> at >>>> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726) >>>> at >>>> org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405) >>>> at >>>> org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206) >>>> at >>>> org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) >>>> at >>>> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) >>>> at org.mortbay.jetty.Server.handle(Server.java:324) >>>> at >>>> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505) >>>> at >>>> org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842) >>>> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648) >>>> at >>>> org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211) >>>> at >>>> org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380) >>>> at >>>> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395) >>>> at >>>> org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450) >>>> Caused by: org.hibernate.exception.ConstraintViolationException: could >>>> not >>>> insert: [edu.ksu.model.User] >>>> at >>>> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) >>>> at >>>> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) >>>> at >>>> org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:40) >>>> at >>>> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2163) >>>> at >>>> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2643) >>>> at >>>> org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:51) >>>> at >>>> org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) >>>> at >>>> org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298) >>>> at >>>> org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181) >>>> at >>>> org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107) >>>> at >>>> org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187) >>>> at >>>> org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172) >>>> at >>>> org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94) >>>> at >>>> org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70) >>>> at >>>> org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507) >>>> at >>>> org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499) >>>> at >>>> org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:495) >>>> at >>>> org.springframework.orm.hibernate3.HibernateTemplate$16.doInHibernate(HibernateTemplate.java:747) >>>> at >>>> org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419) >>>> ... 127 more >>>> Caused by: java.sql.SQLException: Unique constraint violation: >>>> SYS_CT_222 >>>> in >>>> statement [insert into app_user (id, account_expired, account_locked, >>>> address, city, country, postal_code, province, credentials_expired, >>>> email, >>>> account_enabled, first_name, last_name, password, password_hint, >>>> phone_number, username, version, website) values (null, ?, ?, ?, ?, ?, >>>> ?, >>>> ?, >>>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] >>>> at org.hsqldb.jdbc.Util.throwError(Unknown Source) >>>> at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown >>>> Source) >>>> at >>>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) >>>> at >>>> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) >>>> at >>>> org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:33) >>>> ... 143 more >>>> WARN [btpool0-1] UserManagerImpl.saveUser(104) | could not insert: >>>> [edu.ksu.model.User]; nested exception is >>>> org.hibernate.exception.ConstraintViolationException: could not insert: >>>> [edu.ksu.model.User] >>>> >>>> >>>> ============================================== >>>> -- >>>> View this message in context: >>>> http://www.nabble.com/AppFuse-2.0.2-JSF---Editing-a-newly-created-user-----STACK-TRACE-tp19022091s2369p19022091.html >>>> Sent from the AppFuse - User mailing list archive at Nabble.com. >>>> >>>> >>>> --------------------------------------------------------------------- >>>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>>> For additional commands, e-mail: [EMAIL PROTECTED] >>>> >>>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>> For additional commands, e-mail: [EMAIL PROTECTED] >>> >>> >>> >> >> -- >> View this message in context: >> http://www.nabble.com/AppFuse-2.0.2-JSF---Editing-a-newly-created-user-----STACK-TRACE-tp19022091s2369p19028538.html >> Sent from the AppFuse - User mailing list archive at Nabble.com. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/AppFuse-2.0.2-JSF---Editing-a-newly-created-user-----STACK-TRACE-tp19022091s2369p19049591.html Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
