yes, I create database with AppFuse! I use AppFuse with follow 3 step:
1. mvn archetype:create -DarchetypeGroupId=org.appfuse -DarchetypeArtifactId=appfuse-basic-jsf -DremoteRepositories=http://static.appfuse.org/repository -DarchetypeVersion=2.0-m4-SNAPSHOT -DgroupId=com.kooyue2 -DartifactId=kooyue2 2. mvn integration-test 3.mvn jetty:run All is OK and database is created! My OS is Ubuntu Linux mraible wrote: > > 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] > > > -- View this message in context: http://www.nabble.com/zh_CN-submit-ERROR%21%21%21-tf3426079s2369.html#a9552971 Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
