Did you try setting the character set for your db/table/column? You might find this useful:
http://dev.mysql.com/doc/refman/6.0/en/charset-column.html elif On Fri, May 30, 2008 at 10:12 AM, Neil Pitman <[EMAIL PROTECTED]> wrote: > I am using Jetspeed 2.1.2. I am migrating my data for a new webapp. I > have > taken a SQL dump from production as a starting point for the migration. > When I deploy my new app against the old production data and turning up the > log level, I noticed that the j2-admin portlet is redeployed and it fails, > presumably when it tries to deploy some Chinese and Japanese into the > latin-Swedish columns (See logs below). > > > > Up until now, I used the database generated by the installer. I cannot use > that one since I need the production data. I don't understand what it > wants. > > > > Any help would be very appreciated. > > > > Neil > > > > Particial logs: > > > > > INFO: Deployment scanner successfuly started! > > INFO: JetspeedServlet has successfuly started the Jetspeed Portal > Engine.... > > INFO: Jetspeed Initialization complete, Ready to service requests. > > WARN: The provided portlet application j2-admin is a different version > than > in the local node info and the database (db > > -checksum=2697680183, local-checksum=: 3775372276) .... we will reregister > AND redeploy (also to the database) > > 30-May-2008 11:54:03 AM org.apache.catalina.startup.HostConfig deployWAR > > INFO: Deploying web application archive nce-contractAdmin.war > > INFO: Un-Registered the portlet application in the search engine... > j2-admin > > INFO: Remove all registry entries defined for portlet application j2-admin > > INFO: Loading portlet.xml....j2-admin > > [2008-05-30 11:54:21,046]DEBUG 0[main] - > org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java > > :3708) - Configuring event listener class > 'org.apache.myfaces.webapp.StartupServletContextListener' > > [2008-05-30 11:54:40,046]DEBUG 19000[main] - > org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java > > :3708) - Configuring event listener class > 'org.springframework.web.util.Log4jConfigListener' > > [2008-05-30 11:54:40,156]DEBUG 19110[main] - > org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java > > :3708) - Configuring event listener class > 'org.springframework.web.context.ContextLoaderListener' > > [2008-05-30 11:54:40,156]DEBUG 19110[main] - > org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java > > :3708) - Configuring event listener class > 'org.springframework.web.context.request.RequestContextListener' > > [2008-05-30 11:54:40,187]DEBUG 19141[main] - > org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java > > :3747) - Sending application start events > > [2008-05-30 11:54:40,187]DEBUG 19141[main] - > org.apache.myfaces.webapp.StartupServletContextListener.initFaces(StartupSe > > rvletContextListener.java:62) - Initializing MyFaces > > INFO: Loading web.xml....j2-admin > > [2008-05-30 11:54:48,953] INFO 27907[main] - > org.apache.myfaces.config.FacesConfigurator.feedStandardConfig(FacesConfigu > > rator.java:159) - Reading standard config > org/apache/myfaces/resource/standard-faces-config.xm > > > > <snip/> > > > > [2008-05-30 11:45:00,140]DEBUG 5703[main] - > org.apache.myfaces.application.ApplicationImpl.addComponent(ApplicationImpl > > .java:273) - add Component class = javax.faces.component.UICommand for type > = javax.faces.Command > > ERROR: Failed to register portlet application, j2-admin > > org.springframework.jdbc.UncategorizedSQLException: OJB operation; > uncategorized SQLException for SQL []; SQL state [HY0 > > 00]; error code [1366]; Incorrect string value: > '\xE3\x83\x9D\xE3\x83\xBC...' for column 'DISPLAY_NAME' at row 1; nested > > exception is java.sql.SQLException: Incorrect string value: > '\xE3\x83\x9D\xE3\x83\xBC...' for column 'DISPLAY_NAME' at > > row 1 > > at > > org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQ > LStateSQLExceptionTranslator.java > > :124) > > at > > org.springframework.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccess > or.java:107) > > at > > org.springframework.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccesso > r.java:89) > > at > > org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBro > kerTemplate.java:141) > > at > > org.springframework.orm.ojb.PersistenceBrokerTemplate.store(PersistenceBroke > rTemplate.java:241) > > at > > org.apache.jetspeed.components.portletregistry.PersistenceBrokerPortletRegis > try.registerPortletApplication(Pe > > rsistenceBrokerPortletRegistry.java:229) > > 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(AopU > tils.java:310) > > at > > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint > (ReflectiveMethodInvocation.java: > > 182) > > at > > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect > iveMethodInvocation.java:149) > > at > > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(Tr > ansactionInterceptor.java:106) > > at > > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect > iveMethodInvocation.java:171) > > at > > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopPro > xy.java:204) > > at $Proxy4.registerPortletApplication(Unknown Source) > > at > > org.apache.jetspeed.tools.pamanager.PortletApplicationManager.registerPortle > tApplication(PortletApplicationMa > > nager.java:357) > > at > > org.apache.jetspeed.tools.pamanager.PortletApplicationManager.startPA(Portle > tApplicationManager.java:527) > > at > > org.apache.jetspeed.tools.pamanager.PortletApplicationManager.startPA(Portle > tApplicationManager.java:419) > > at > > org.apache.jetspeed.tools.pamanager.PortletApplicationManager.startPortletAp > plication(PortletApplicationManag > > er.java:194) > > at > > org.apache.jetspeed.container.JetspeedContainerServlet.attemptStart(Jetspeed > ContainerServlet.java:174) > > at > > org.apache.jetspeed.container.JetspeedContainerServlet.access$200(JetspeedCo > ntainerServlet.java:57) > > at > > org.apache.jetspeed.container.JetspeedContainerServlet$1.run(JetspeedContain > erServlet.java:145) > > at java.util.TimerThread.mainLoop(Timer.java:512) > > at java.util.TimerThread.run(Timer.java:462) > > Caused by: java.sql.SQLException: Incorrect string value: > '\xE3\x83\x9D\xE3\x83\xBC...' for column 'DISPLAY_NAME' at row > > 1 > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) > > at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) > > at > > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332 > ) > > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) > > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) > > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) > > at > > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating > PreparedStatement.java:102) > > at > > org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessImp > l.java:216) > > at > > org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroker > Impl.java:1754) > > at > > org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl > .java:813) > > at > > org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl > .java:726) > > at > > org.apache.ojb.broker.core.PersistenceBrokerImpl.storeAndLinkOneToMany(Persi > stenceBrokerImpl.java:1057) > > at > > org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollections(Persistenc > eBrokerImpl.java:928) > > at > > org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroker > Impl.java:1776) > > at > > org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl > .java:813) > > at > > org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl > .java:726) > > at > > org.apache.ojb.broker.core.PersistenceBrokerImpl.storeAndLinkOneToMany(Persi > stenceBrokerImpl.java:1057) > > at > > org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollections(Persistenc > eBrokerImpl.java:928) > > at > > org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroker > Impl.java:1776) > > at > > org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl > .java:813) > > at > > org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl > .java:726) > > at > > org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersi > stenceBroker.java:175) > > at > > org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersi > stenceBroker.java:175) > > at > > org.springframework.orm.ojb.PersistenceBrokerTemplate$9.doInPersistenceBroke > r(PersistenceBrokerTemplate.java: > > 243) > > at > > org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBro > kerTemplate.java:138) > > ... 22 more > > > >
