Did you create the database with AppFuse, or by hand? Looking at your SQL, I believe this:
DEFAULT CHARSET=latin1; Should be: DEFAULT CHARSET=utf8; Matt On 3/19/07, jason.jiang <[EMAIL PROTECTED]> wrote:
http://demo.appfuse.org/appfuse-jsf is OK! But I don't edit pom.xml this is my pom.xml and mysql.sql http://www.nabble.com/file/7263/kooyue2.sql kooyue2.sql http://www.nabble.com/file/7264/pom.xml pom.xml mraible wrote: > > Can you check and make sure your MySQL installation supports UTF-8? > > Does this issue happen on the demo? > > http://demo.appfuse.org/appfuse-jsf > > Matt > > On 3/19/07, jason.jiang <[EMAIL PROTECTED]> wrote: >> >> i work with Appfuse2 M4 (JSF) >> >> I get the following error when I try to submit signup with chinese(zh_CN) >> "first_name" and "last_name" ! >> >> "Caused by: java.sql.SQLException: Incorrect string value: '\xE6\x97\xAD' >> for column 'first_name' at row 1" >> >> >> http://www.nabble.com/file/7259/saveError.gif saveError.gif >> >> Full Error: >> -------------------------------------------------------------------------------- >> javax.faces.FacesException: Error calling action method of component with >> id >> signupForm:save >> at >> org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:72) >> at javax.faces.component.UICommand.broadcast(UICommand.java:109) >> 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:95) >> at >> org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:70) >> at javax.faces.webapp.FacesServlet.service(FacesServlet.java:139) >> at >> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:447) >> at >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1050) >> 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:1041) >> at >> org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:144) >> at >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) >> at >> org.appfuse.webapp.filter.MessageFilter.doFilter(MessageFilter.java:45) >> at >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) >> 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:1041) >> at >> org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) >> at >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) >> at >> org.appfuse.webapp.filter.LocaleFilter.doFilterInternal(LocaleFilter.java:63) >> at >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77) >> at >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) >> at >> com.opensymphony.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:42) >> at >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) >> at >> org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:183) >> at >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77) >> at >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) >> at >> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) >> at >> org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) >> at >> org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) >> at >> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) >> at >> org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) >> at >> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) >> at >> org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) >> at >> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) >> at >> org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:135) >> at >> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) >> at >> org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) >> at >> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) >> at >> org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) >> at >> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) >> at >> org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229) >> at >> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) >> at >> org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) >> at >> org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) >> at >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) >> at >> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:77) >> at >> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77) >> at >> org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041) >> at >> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:354) >> at >> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:226) >> at >> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:621) >> at >> org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:149) >> at >> org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:123) >> at >> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141) >> at org.mortbay.jetty.Server.handle(Server.java:269) >> at >> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:430) >> at >> org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:692) >> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:617) >> at >> org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:199) >> at >> org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:339) >> at >> org.mortbay.jetty.nio.HttpChannelEndPoint.run(HttpChannelEndPoint.java:270) >> at >> org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475) >> Caused by: javax.faces.el.EvaluationException: /signup.xhtml @150,120 >> action="#{signupForm.save}": >> org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: >> could not insert: [org.appfuse.model.User]; uncategorized SQLException >> for >> SQL [insert into app_user (username, email, password_hint, first_name, >> last_name, phone_number, website, account_expired, account_locked, >> credentials_expired, city, province, postal_code, address, country, >> version, >> account_enabled, password) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, >> ?, >> ?, ?, ?, ?)]; SQL state [HY000]; error code [1366]; Incorrect string >> value: >> '\xE6\x97\xAD' for column 'first_name' at row 1; nested exception is >> java.sql.SQLException: Incorrect string value: '\xE6\x97\xAD' for column >> 'first_name' at row 1 >> at >> com.sun.facelets.el.LegacyMethodBinding.invoke(LegacyMethodBinding.java:73) >> at >> org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:61) >> ... 66 more >> Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate >> operation: could not insert: [org.appfuse.model.User]; uncategorized >> SQLException for SQL [insert into app_user (username, email, >> password_hint, >> first_name, last_name, phone_number, website, account_expired, >> account_locked, credentials_expired, city, province, postal_code, >> address, >> country, version, account_enabled, password) values (?, ?, ?, ?, ?, ?, ?, >> ?, >> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [HY000]; error code [1366]; >> Incorrect string value: '\xE6\x97\xAD' for column 'first_name' at row 1; >> nested exception is java.sql.SQLException: Incorrect string value: >> '\xE6\x97\xAD' for column 'first_name' at row 1 >> at >> org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:120) >> at >> org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276) >> at >> org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424) >> at >> org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410) >> at >> org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372) >> at >> org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:681) >> at >> org.appfuse.dao.hibernate.UserDaoHibernate.saveUser(UserDaoHibernate.java:39) >> 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:585) >> at >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:299) >> at >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196) >> at $Proxy30.saveUser(Unknown Source) >> at >> org.appfuse.service.impl.UserManagerImpl.saveUser(UserManagerImpl.java:59) >> 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:585) >> at >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:299) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:172) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139) >> at >> org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) >> at >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) >> at >> org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:50) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) >> at >> org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) >> at >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) >> at >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) >> at $Proxy33.saveUser(Unknown Source) >> at org.appfuse.webapp.action.SignupForm.save(SignupForm.java:63) >> 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:585) >> at com.sun.el.parser.AstValue.invoke(AstValue.java:151) >> at >> com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:283) >> at >> com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68) >> at >> com.sun.facelets.el.LegacyMethodBinding.invoke(LegacyMethodBinding.java:69) >> ... 67 more >> Caused by: java.sql.SQLException: Incorrect string value: '\xE6\x97\xAD' >> for >> column 'first_name' at row 1 >> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) >> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) >> at >> com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169) >> at >> com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693) >> at >> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404) >> at >> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318) >> at >> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303) >> at >> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) >> at >> org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73) >> at >> org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33) >> at >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2108) >> at >> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2588) >> at >> org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48) >> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) >> at >> org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:290) >> at >> org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:180) >> at >> org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:108) >> at >> org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186) >> at >> org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175) >> at >> org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:98) >> 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:684) >> at >> org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367) >> ... 105 more >> ------------------------------------------------------------------------- >> >> How that thing occur? Any idea about how to fix it? >> >> Thanks! >> >> jason.jiang >> >> -- >> View this message in context: >> http://www.nabble.com/zh_CN-submit-ERROR%21%21%21-tf3426079s2369.html#a9549223 >> Sent from the AppFuse - User mailing list archive at Nabble.com. >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > > -- > http://raibledesigns.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/zh_CN-submit-ERROR%21%21%21-tf3426079s2369.html#a9549990 Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- http://raibledesigns.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
