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
