You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Elif Guner <el...@gmail.com> on 2008/06/02 21:29:16 UTC
Re: Deployment error prevents Login Portlet
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 <ne...@sympatico.ca>
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:elif.guner@gmail.com]
> 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 <ne...@sympatico.ca>
> 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: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>