Hi Neil, I've had no problems entering some German characters into a mysql database. The following might be old but there is some useful information if you are still interested:
http://mysqldump.azundris.com/archives/60-Handling-character-sets.html When you check character_set_server, collation_server, character_set_database, collation_database system variables do you see the right character set? Have you also checked the table and column after restoring the db? Sorry I am not much help. Elif On Fri, May 30, 2008 at 6:43 PM, Neil Pitman <[EMAIL PROTECTED]> wrote: > > I've done a meticulous analysis of the character sets used by the working > and non-working DBs. Since I used mysqldump, the character sets are used > included in the dump. I restored the DB on my development server and > pointed alternatively my development JetSpeed and a collegue's development > JetSpeed to it, with failures on the restored dump (the other was from the > installer). I further restored the dump to a test server (with similar) > results and compared the tables column by column and I cannot detect > differences. > > > -----Original Message----- > From: Elif Guner [mailto:[EMAIL PROTECTED] > Sent: May 30, 2008 5:04 PM > To: Jetspeed Users List > Subject: Re: Deployment error prevents Login Portlet > > 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 > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
