Jahia5.0.4_02 on jBoss 4.0.5 crash at import
PIRONET Benoît <[email protected]> Tue, 23 Sep 2008 08:50:05 +0200
| Newsgroups | gmane.comp.cms.jahia.devel |
|---|---|
| Message-ID | <27112111568D6346939B1DABE49CD100CE8A25@lux-mail.lux.cronos-technologies.com> |
Hello list,
I'm trying to export/import a Jahia site from
windows
jahia5.0.4_02
tomcat
hsqldb
to
unix
jahia5.0.4_02
jBoss 4.0.5
oracle 9.0.2
The new jahia-ds.xml:
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>jahiaDS</jndi-name>
<use-java-context>false</use-java-context>
<max-pool-size>100</max-pool-size>
<min-pool-size>10</min-pool-size>
<connection-url>jdbc:oracle:oci:@xxxxx</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>xxxxx</user-name>
<password>xxxxxx</password>
</local-tx-datasource>
</datasources>
And the database drivers are: ojdbc14.jar
The export is ok, but the import fails with this error (after the screen where I choose the name of the imported site):
2008-09-23 08:39:37,426: INFO [STDOUT] - 2008-09-23 08:39:37,421: ERROR [org.ja
hia.admin.sites.ManageSites] - Error while adding site
org.jahia.exceptions.JahiaException: User message=Error while shutting down sche
duler service, System message=Error while shutting down scheduler service, root
cause:Driver's Blob representation is of an unsupported type: oracle.sql.BLOB ro
ot cause=java.sql.SQLException: Driver's Blob representation is of an unsupporte
d type: oracle.sql.BLOB
at org.jahia.services.scheduler.SchedulerServiceImpl.getJahiaException(S
chedulerServiceImpl.java:564)
at org.jahia.services.scheduler.SchedulerServiceImpl.scheduleJobNow(Sche
dulerServiceImpl.java:358)
at org.jahia.services.scheduler.SchedulerServiceImpl$$FastClassByCGLIB$$
69d9b62e.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocatio
n.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:122)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(A
bstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:606)
at org.jahia.services.scheduler.SchedulerServiceImpl$$EnhancerByCGLIB$$8
d91bbfb.scheduleJobNow(<generated>)
at org.jahia.admin.sites.ManageSites.terminateAdd(ManageSites.java:1175)
at org.jahia.admin.sites.ManageSites.createSite(ManageSites.java:2562)
at org.jahia.admin.sites.ManageSites.processFileImport(ManageSites.java:
2469)
at org.jahia.admin.sites.ManageSites.userRequestDispatcher(ManageSites.j
ava:205)
at org.jahia.admin.sites.ManageSites.<init>(ManageSites.java:154)
at org.jahia.bin.JahiaAdministration.userRequestDispatcher(JahiaAdminist
ration.java:404)
at org.jahia.bin.JahiaAdministration.service(JahiaAdministration.java:26
9)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.jahia.bin.filters.esi.ESIFilter.doFilter(ESIFilter.java:110)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
lter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
yAssociationValve.java:175)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:432)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
e.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConne
ctionValve.java:156)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
kerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Driver's Blob representation is of an unsuppor
ted type: oracle.sql.BLOB
at org.quartz.impl.jdbcjobstore.oracle.OracleDelegate.writeDataToBlob(Or
acleDelegate.java:726)
at org.quartz.impl.jdbcjobstore.oracle.OracleDelegate.insertJobDetail(Or
acleDelegate.java:204)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport
.java:846)
at org.quartz.impl.jdbcjobstore.JobStoreTX.storeJobAndTrigger(JobStoreTX
.java:163)
at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:612)
at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:238)
at org.jahia.services.scheduler.SchedulerServiceImpl.scheduleJobNow(Sche
dulerServiceImpl.java:356)
... 39 more
java.sql.SQLException: Driver's Blob representation is of an unsupported type: o
racle.sql.BLOB
at org.quartz.impl.jdbcjobstore.oracle.OracleDelegate.writeDataToBlob(Or
acleDelegate.java:726)
at org.quartz.impl.jdbcjobstore.oracle.OracleDelegate.insertJobDetail(Or
acleDelegate.java:204)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport
.java:846)
at org.quartz.impl.jdbcjobstore.JobStoreTX.storeJobAndTrigger(JobStoreTX
.java:163)
at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:612)
at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:238)
at org.jahia.services.scheduler.SchedulerServiceImpl.scheduleJobNow(Sche
dulerServiceImpl.java:356)
at org.jahia.services.scheduler.SchedulerServiceImpl$$FastClassByCGLIB$$
69d9b62e.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocatio
n.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:122)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(A
bstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:606)
at org.jahia.services.scheduler.SchedulerServiceImpl$$EnhancerByCGLIB$$8
d91bbfb.scheduleJobNow(<generated>)
at org.jahia.admin.sites.ManageSites.terminateAdd(ManageSites.java:1175)
at org.jahia.admin.sites.ManageSites.createSite(ManageSites.java:2562)
at org.jahia.admin.sites.ManageSites.processFileImport(ManageSites.java:
2469)
at org.jahia.admin.sites.ManageSites.userRequestDispatcher(ManageSites.j
ava:205)
at org.jahia.admin.sites.ManageSites.<init>(ManageSites.java:154)
at org.jahia.bin.JahiaAdministration.userRequestDispatcher(JahiaAdminist
ration.java:404)
at org.jahia.bin.JahiaAdministration.service(JahiaAdministration.java:26
9)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.jahia.bin.filters.esi.ESIFilter.doFilter(ESIFilter.java:110)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
lter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
yAssociationValve.java:175)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:432)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
e.java:74)
at org.apache.catalina.co
2008-09-23 08:39:37,427: INFO [STDOUT] - re.StandardHostValve.invoke(StandardHo
stValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConne
ctionValve.java:156)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
kerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
An other error caused by the same problem is:
2008-09-23 08:39:35,364: INFO [STDOUT] - 2008-09-23 08:39:35,363: INFO [org.ap
ache.slide.security.SecurityImpl] - Action aggregations loaded successfully
2008-09-23 08:39:36,492: INFO [STDOUT] - 2008-09-23 08:39:36,491: INFO [org.ap
ache.slide.security.SecurityImpl] - Action aggregations loaded successfully
2008-09-23 08:39:37,379: ERROR [STDERR] - java.sql.SQLException: Driver's Blob r
epresentation is of an unsupported type: oracle.sql.BLOB
2008-09-23 08:39:37,381: ERROR [STDERR] - at org.quartz.impl.jdbcjobstore.
oracle.OracleDelegate.writeDataToBlob(OracleDelegate.java:726)
2008-09-23 08:39:37,382: ERROR [STDERR] - at org.quartz.impl.jdbcjobstore.
oracle.OracleDelegate.insertJobDetail(OracleDelegate.java:204)
2008-09-23 08:39:37,383: ERROR [STDERR] - at org.quartz.impl.jdbcjobstore.
JobStoreSupport.storeJob(JobStoreSupport.java:846)
2008-09-23 08:39:37,383: ERROR [STDERR] - at org.quartz.impl.jdbcjobstore.
JobStoreTX.storeJobAndTrigger(JobStoreTX.java:163)
2008-09-23 08:39:37,384: ERROR [STDERR] - at org.quartz.core.QuartzSchedul
er.scheduleJob(QuartzScheduler.java:612)
2008-09-23 08:39:37,385: ERROR [STDERR] - at org.quartz.impl.StdScheduler.
scheduleJob(StdScheduler.java:238)
2008-09-23 08:39:37,386: ERROR [STDERR] - at org.jahia.services.scheduler.
SchedulerServiceImpl.scheduleJobNow(SchedulerServiceImpl.java:356)
2008-09-23 08:39:37,387: ERROR [STDERR] - at org.jahia.services.scheduler.
SchedulerServiceImpl$$FastClassByCGLIB$$69d9b62e.invoke(<generated>)
2008-09-23 08:39:37,387: ERROR [STDERR] - at net.sf.cglib.proxy.MethodProx
y.invoke(MethodProxy.java:149)
2008-09-23 08:39:37,388: ERROR [STDERR] - at org.springframework.aop.frame
work.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:66
1)
2008-09-23 08:39:37,389: ERROR [STDERR] - at org.springframework.aop.frame
work.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
2008-09-23 08:39:37,390: ERROR [STDERR] - at org.springframework.aop.inter
ceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
2008-09-23 08:39:37,390: ERROR [STDERR] - at org.springframework.aop.frame
work.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
2008-09-23 08:39:37,391: ERROR [STDERR] - at org.springframework.aop.frame
work.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:606)
2008-09-23 08:39:37,392: ERROR [STDERR] - at org.jahia.services.scheduler.
SchedulerServiceImpl$$EnhancerByCGLIB$$8d91bbfb.scheduleJobNow(<generated>)
2008-09-23 08:39:37,393: ERROR [STDERR] - at org.jahia.admin.sites.ManageS
ites.terminateAdd(ManageSites.java:1175)
2008-09-23 08:39:37,394: ERROR [STDERR] - at org.jahia.admin.sites.ManageS
ites.createSite(ManageSites.java:2562)
2008-09-23 08:39:37,394: ERROR [STDERR] - at org.jahia.admin.sites.ManageS
ites.processFileImport(ManageSites.java:2469)
2008-09-23 08:39:37,395: ERROR [STDERR] - at org.jahia.admin.sites.ManageS
ites.userRequestDispatcher(ManageSites.java:205)
2008-09-23 08:39:37,396: ERROR [STDERR] - at org.jahia.admin.sites.ManageS
ites.<init>(ManageSites.java:154)
2008-09-23 08:39:37,397: ERROR [STDERR] - at org.jahia.bin.JahiaAdministra
tion.userRequestDispatcher(JahiaAdministration.java:404)
2008-09-23 08:39:37,398: ERROR [STDERR] - at org.jahia.bin.JahiaAdministra
tion.service(JahiaAdministration.java:269)
2008-09-23 08:39:37,399: ERROR [STDERR] - at javax.servlet.http.HttpServle
t.service(HttpServlet.java:810)
2008-09-23 08:39:37,400: ERROR [STDERR] - at org.apache.catalina.core.Appl
icationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
2008-09-23 08:39:37,400: ERROR [STDERR] - at org.apache.catalina.core.Appl
icationFilterChain.doFilter(ApplicationFilterChain.java:173)
2008-09-23 08:39:37,401: ERROR [STDERR] - at org.jahia.bin.filters.esi.ESI
Filter.doFilter(ESIFilter.java:110)
2008-09-23 08:39:37,402: ERROR [STDERR] - at org.apache.catalina.core.Appl
icationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
2008-09-23 08:39:37,403: ERROR [STDERR] - at org.apache.catalina.core.Appl
icationFilterChain.doFilter(ApplicationFilterChain.java:173)
2008-09-23 08:39:37,403: ERROR [STDERR] - at org.jboss.web.tomcat.filters.
ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
2008-09-23 08:39:37,404: ERROR [STDERR] - at org.apache.catalina.core.Appl
icationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
2008-09-23 08:39:37,405: ERROR [STDERR] - at org.apache.catalina.core.Appl
icationFilterChain.doFilter(ApplicationFilterChain.java:173)
2008-09-23 08:39:37,406: ERROR [STDERR] - at org.apache.catalina.core.Stan
dardWrapperValve.invoke(StandardWrapperValve.java:213)
2008-09-23 08:39:37,407: ERROR [STDERR] - at org.apache.catalina.core.Stan
dardContextValve.invoke(StandardContextValve.java:178)
2008-09-23 08:39:37,408: ERROR [STDERR] - at org.jboss.web.tomcat.security
.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
2008-09-23 08:39:37,409: ERROR [STDERR] - at org.apache.catalina.authentic
ator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
2008-09-23 08:39:37,410: ERROR [STDERR] - at org.jboss.web.tomcat.security
.JaccContextValve.invoke(JaccContextValve.java:74)
2008-09-23 08:39:37,410: ERROR [STDERR] - at org.apache.catalina.core.Stan
dardHostValve.invoke(StandardHostValve.java:126)
2008-09-23 08:39:37,411: ERROR [STDERR] - at org.apache.catalina.valves.Er
rorReportValve.invoke(ErrorReportValve.java:105)
2008-09-23 08:39:37,412: ERROR [STDERR] - at org.jboss.web.tomcat.tc5.jca.
CachedConnectionValve.invoke(CachedConnectionValve.java:156)
2008-09-23 08:39:37,413: ERROR [STDERR] - at org.apache.catalina.core.Stan
dardEngineValve.invoke(StandardEngineValve.java:107)
2008-09-23 08:39:37,414: ERROR [STDERR] - at org.apache.catalina.connector
.CoyoteAdapter.service(CoyoteAdapter.java:148)
2008-09-23 08:39:37,414: ERROR [STDERR] - at org.apache.coyote.http11.Http
11Processor.process(Http11Processor.java:869)
2008-09-23 08:39:37,415: ERROR [STDERR] - at org.apache.coyote.http11.Http
11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java
:664)
2008-09-23 08:39:37,416: ERROR [STDERR] - at org.apache.tomcat.util.net.Po
olTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
2008-09-23 08:39:37,417: ERROR [STDERR] - at org.apache.tomcat.util.net.Ma
sterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
2008-09-23 08:39:37,417: ERROR [STDERR] - at java.lang.Thread.run(Thread.j
ava:595)
Does anybody know how to solve this issue?
Thank you in advance,
Benoit Pironet
_______________________________________________
dev_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/dev_list