Re: Jahia5.0.4_02 on jBoss 4.0.5 crash at import

Hello,

this seems to be a class loading issue. Please make sure that you have =

the Oracle driver JAR just at one place -> e.g. =

JBOSS_HOME/server/default/lib and remove it from WEB-INF\lib in Jahia's =

webapp.

Regards,
Benjamin

On 23.09.2008 08:50 PIRONET Beno=EEt wrote:
> 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=3D"1.0" encoding=3D"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=3DError while shutting =
down sche
> duler service, System message=3DError while shutting down scheduler servi=
ce, root
> cause:Driver's Blob representation is of an unsupported type: oracle.sql.=
BLOB ro
> ot cause=3Djava.sql.SQLException: Driver's Blob representation is of an u=
nsupporte
> d type: oracle.sql.BLOB
>         at org.jahia.services.scheduler.SchedulerServiceImpl.getJahiaExce=
ption(S
> chedulerServiceImpl.java:564)
>         at org.jahia.services.scheduler.SchedulerServiceImpl.scheduleJobN=
ow(Sche
> dulerServiceImpl.java:358)
>         at org.jahia.services.scheduler.SchedulerServiceImpl$$FastClassBy=
CGLIB$$
> 69d9b62e.invoke(<generated>)
>         at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
>         at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodIn=
vocatio
> n.invokeJoinpoint(Cglib2AopProxy.java:661)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.p=
roceed(
> ReflectiveMethodInvocation.java:122)
>         at org.springframework.aop.interceptor.AbstractTraceInterceptor.i=
nvoke(A
> bstractTraceInterceptor.java:80)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.p=
roceed(
> ReflectiveMethodInvocation.java:144)
>         at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvise=
dInterc
> eptor.intercept(Cglib2AopProxy.java:606)
>         at org.jahia.services.scheduler.SchedulerServiceImpl$$EnhancerByC=
GLIB$$8
> d91bbfb.scheduleJobNow(<generated>)
>         at org.jahia.admin.sites.ManageSites.terminateAdd(ManageSites.jav=
a:1175)
>         at org.jahia.admin.sites.ManageSites.createSite(ManageSites.java:=
2562)
>         at org.jahia.admin.sites.ManageSites.processFileImport(ManageSite=
s.java:
> 2469)
>         at org.jahia.admin.sites.ManageSites.userRequestDispatcher(Manage=
Sites.j
> ava:205)
>         at org.jahia.admin.sites.ManageSites.<init>(ManageSites.java:154)
>         at org.jahia.bin.JahiaAdministration.userRequestDispatcher(JahiaA=
dminist
> 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.internalDoFilt=
er(Appl
> icationFilterChain.java:252)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli=
cationF
> ilterChain.java:173)
>         at org.jahia.bin.filters.esi.ESIFilter.doFilter(ESIFilter.java:11=
0)
>         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilt=
er(Appl
> icationFilterChain.java:202)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli=
cationF
> ilterChain.java:173)
>         at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyH=
eaderFi
> lter.java:96)
>         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilt=
er(Appl
> icationFilterChain.java:202)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli=
cationF
> ilterChain.java:173)
>         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardW=
rapperV
> alve.java:213)
>         at org.apache.catalina.core.StandardContextValve.invoke(StandardC=
ontextV
> alve.java:178)
>         at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(=
Securit
> yAssociationValve.java:175)
>         at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Aut=
hentica
> torBase.java:432)
>         at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCont=
extValv
> e.java:74)
>         at org.apache.catalina.core.StandardHostValve.invoke(StandardHost=
Valve.j
> ava:126)
>         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport=
Valve.j
> ava:105)
>         at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(Cach=
edConne
> ctionValve.java:156)
>         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEn=
gineVal
> ve.java:107)
>         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdap=
ter.jav
> a:148)
>         at org.apache.coyote.http11.Http11Processor.process(Http11Process=
or.java
> :869)
>         at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHa=
ndler.p
> rocessConnection(Http11BaseProtocol.java:664)
>         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolT=
cpEndpo
> int.java:527)
>         at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterS=
laveWor
> kerThread.java:112)
>         at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.SQLException: Driver's Blob representation is of an u=
nsuppor
> ted type: oracle.sql.BLOB
>         at org.quartz.impl.jdbcjobstore.oracle.OracleDelegate.writeDataTo=
Blob(Or
> acleDelegate.java:726)
>         at org.quartz.impl.jdbcjobstore.oracle.OracleDelegate.insertJobDe=
tail(Or
> acleDelegate.java:204)
>         at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStore=
Support
> .java:846)
>         at org.quartz.impl.jdbcjobstore.JobStoreTX.storeJobAndTrigger(Job=
StoreTX
> .java:163)
>         at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.ja=
va:612)
>         at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:238)
>         at org.jahia.services.scheduler.SchedulerServiceImpl.scheduleJobN=
ow(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.writeDataTo=
Blob(Or
> acleDelegate.java:726)
>         at org.quartz.impl.jdbcjobstore.oracle.OracleDelegate.insertJobDe=
tail(Or
> acleDelegate.java:204)
>         at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStore=
Support
> .java:846)
>         at org.quartz.impl.jdbcjobstore.JobStoreTX.storeJobAndTrigger(Job=
StoreTX
> .java:163)
>         at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.ja=
va:612)
>         at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:238)
>         at org.jahia.services.scheduler.SchedulerServiceImpl.scheduleJobN=
ow(Sche
> dulerServiceImpl.java:356)
>         at org.jahia.services.scheduler.SchedulerServiceImpl$$FastClassBy=
CGLIB$$
> 69d9b62e.invoke(<generated>)
>         at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
>         at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodIn=
vocatio
> n.invokeJoinpoint(Cglib2AopProxy.java:661)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.p=
roceed(
> ReflectiveMethodInvocation.java:122)
>         at org.springframework.aop.interceptor.AbstractTraceInterceptor.i=
nvoke(A
> bstractTraceInterceptor.java:80)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.p=
roceed(
> ReflectiveMethodInvocation.java:144)
>         at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvise=
dInterc
> eptor.intercept(Cglib2AopProxy.java:606)
>         at org.jahia.services.scheduler.SchedulerServiceImpl$$EnhancerByC=
GLIB$$8
> d91bbfb.scheduleJobNow(<generated>)
>         at org.jahia.admin.sites.ManageSites.terminateAdd(ManageSites.jav=
a:1175)
>         at org.jahia.admin.sites.ManageSites.createSite(ManageSites.java:=
2562)
>         at org.jahia.admin.sites.ManageSites.processFileImport(ManageSite=
s.java:
> 2469)
>         at org.jahia.admin.sites.ManageSites.userRequestDispatcher(Manage=
Sites.j
> ava:205)
>         at org.jahia.admin.sites.ManageSites.<init>(ManageSites.java:154)
>         at org.jahia.bin.JahiaAdministration.userRequestDispatcher(JahiaA=
dminist
> 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.internalDoFilt=
er(Appl
> icationFilterChain.java:252)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli=
cationF
> ilterChain.java:173)
>         at org.jahia.bin.filters.esi.ESIFilter.doFilter(ESIFilter.java:11=
0)
>         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilt=
er(Appl
> icationFilterChain.java:202)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli=
cationF
> ilterChain.java:173)
>         at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyH=
eaderFi
> lter.java:96)
>         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilt=
er(Appl
> icationFilterChain.java:202)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(Appli=
cationF
> ilterChain.java:173)
>         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardW=
rapperV
> alve.java:213)
>         at org.apache.catalina.core.StandardContextValve.invoke(StandardC=
ontextV
> alve.java:178)
>         at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(=
Securit
> yAssociationValve.java:175)
>         at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Aut=
hentica
> torBase.java:432)
>         at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCont=
extValv
> e.java:74)
>         at org.apache.catalina.co
> 2008-09-23 08:39:37,427: INFO  [STDOUT] - re.StandardHostValve.invoke(Sta=
ndardHo
> stValve.java:126)
>         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReport=
Valve.j
> ava:105)
>         at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(Cach=
edConne
> ctionValve.java:156)
>         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEn=
gineVal
> ve.java:107)
>         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdap=
ter.jav
> a:148)
>         at org.apache.coyote.http11.Http11Processor.process(Http11Process=
or.java
> :869)
>         at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHa=
ndler.p
> rocessConnection(Http11BaseProtocol.java:664)
>         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolT=
cpEndpo
> int.java:527)
>         at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterS=
laveWor
> 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 successful=
ly
> 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 successful=
ly
> 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.jdbcjo=
bstore.
> oracle.OracleDelegate.writeDataToBlob(OracleDelegate.java:726)
> 2008-09-23 08:39:37,382: ERROR [STDERR] -       at org.quartz.impl.jdbcjo=
bstore.
> oracle.OracleDelegate.insertJobDetail(OracleDelegate.java:204)
> 2008-09-23 08:39:37,383: ERROR [STDERR] -       at org.quartz.impl.jdbcjo=
bstore.
> JobStoreSupport.storeJob(JobStoreSupport.java:846)
> 2008-09-23 08:39:37,383: ERROR [STDERR] -       at org.quartz.impl.jdbcjo=
bstore.
> JobStoreTX.storeJobAndTrigger(JobStoreTX.java:163)
> 2008-09-23 08:39:37,384: ERROR [STDERR] -       at org.quartz.core.Quartz=
Schedul
> er.scheduleJob(QuartzScheduler.java:612)
> 2008-09-23 08:39:37,385: ERROR [STDERR] -       at org.quartz.impl.StdSch=
eduler.
> scheduleJob(StdScheduler.java:238)
> 2008-09-23 08:39:37,386: ERROR [STDERR] -       at org.jahia.services.sch=
eduler.
> SchedulerServiceImpl.scheduleJobNow(SchedulerServiceImpl.java:356)
> 2008-09-23 08:39:37,387: ERROR [STDERR] -       at org.jahia.services.sch=
eduler.
> SchedulerServiceImpl$$FastClassByCGLIB$$69d9b62e.invoke(<generated>)
> 2008-09-23 08:39:37,387: ERROR [STDERR] -       at net.sf.cglib.proxy.Met=
hodProx
> y.invoke(MethodProxy.java:149)
> 2008-09-23 08:39:37,388: ERROR [STDERR] -       at org.springframework.ao=
p.frame
> work.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.=
java:66
> 1)
> 2008-09-23 08:39:37,389: ERROR [STDERR] -       at org.springframework.ao=
p.frame
> work.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:1=
22)
> 2008-09-23 08:39:37,390: ERROR [STDERR] -       at org.springframework.ao=
p.inter
> ceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
> 2008-09-23 08:39:37,390: ERROR [STDERR] -       at org.springframework.ao=
p.frame
> work.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:1=
44)
> 2008-09-23 08:39:37,391: ERROR [STDERR] -       at org.springframework.ao=
p.frame
> work.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.ja=
va:606)
> 2008-09-23 08:39:37,392: ERROR [STDERR] -       at org.jahia.services.sch=
eduler.
> 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.JahiaAdm=
inistra
> tion.userRequestDispatcher(JahiaAdministration.java:404)
> 2008-09-23 08:39:37,398: ERROR [STDERR] -       at org.jahia.bin.JahiaAdm=
inistra
> tion.service(JahiaAdministration.java:269)
> 2008-09-23 08:39:37,399: ERROR [STDERR] -       at javax.servlet.http.Htt=
pServle
> t.service(HttpServlet.java:810)
> 2008-09-23 08:39:37,400: ERROR [STDERR] -       at org.apache.catalina.co=
re.Appl
> icationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> 2008-09-23 08:39:37,400: ERROR [STDERR] -       at org.apache.catalina.co=
re.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.co=
re.Appl
> icationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
> 2008-09-23 08:39:37,403: ERROR [STDERR] -       at org.apache.catalina.co=
re.Appl
> icationFilterChain.doFilter(ApplicationFilterChain.java:173)
> 2008-09-23 08:39:37,403: ERROR [STDERR] -       at org.jboss.web.tomcat.f=
ilters.
> ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
> 2008-09-23 08:39:37,404: ERROR [STDERR] -       at org.apache.catalina.co=
re.Appl
> icationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
> 2008-09-23 08:39:37,405: ERROR [STDERR] -       at org.apache.catalina.co=
re.Appl
> icationFilterChain.doFilter(ApplicationFilterChain.java:173)
> 2008-09-23 08:39:37,406: ERROR [STDERR] -       at org.apache.catalina.co=
re.Stan
> dardWrapperValve.invoke(StandardWrapperValve.java:213)
> 2008-09-23 08:39:37,407: ERROR [STDERR] -       at org.apache.catalina.co=
re.Stan
> dardContextValve.invoke(StandardContextValve.java:178)
> 2008-09-23 08:39:37,408: ERROR [STDERR] -       at org.jboss.web.tomcat.s=
ecurity
> .SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
> 2008-09-23 08:39:37,409: ERROR [STDERR] -       at org.apache.catalina.au=
thentic
> ator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
> 2008-09-23 08:39:37,410: ERROR [STDERR] -       at org.jboss.web.tomcat.s=
ecurity
> .JaccContextValve.invoke(JaccContextValve.java:74)
> 2008-09-23 08:39:37,410: ERROR [STDERR] -       at org.apache.catalina.co=
re.Stan
> dardHostValve.invoke(StandardHostValve.java:126)
> 2008-09-23 08:39:37,411: ERROR [STDERR] -       at org.apache.catalina.va=
lves.Er
> rorReportValve.invoke(ErrorReportValve.java:105)
> 2008-09-23 08:39:37,412: ERROR [STDERR] -       at org.jboss.web.tomcat.t=
c5.jca.
> CachedConnectionValve.invoke(CachedConnectionValve.java:156)
> 2008-09-23 08:39:37,413: ERROR [STDERR] -       at org.apache.catalina.co=
re.Stan
> dardEngineValve.invoke(StandardEngineValve.java:107)
> 2008-09-23 08:39:37,414: ERROR [STDERR] -       at org.apache.catalina.co=
nnector
> .CoyoteAdapter.service(CoyoteAdapter.java:148)
> 2008-09-23 08:39:37,414: ERROR [STDERR] -       at org.apache.coyote.http=
11.Http
> 11Processor.process(Http11Processor.java:869)
> 2008-09-23 08:39:37,415: ERROR [STDERR] -       at org.apache.coyote.http=
11.Http
> 11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtoc=
ol.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(T=
hread.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
>
>   =

_______________________________________________
dev_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/dev_list