Bonjour,
Avec le build 15671 de la version 5 de Jahia je tente deffectuer une
installation avec une base Oracle.
La première phase seffectue normalement.
Lors du redémarrage de Tomcat jobtient des erreurs et Jahia ne démarre pas.
En regardant par rapport à une installation sous mysql je maperçois quil
manque 2 tables :jahia_statitics et jahia_lock_non_excl . Si je les rajoute
« à la main », cest à dire directement sur la base ou en rajoutant les deux
« create table » dans le script de création, je passe cette première étape
mais certaines tables ne sont alors pas populées. Jobtiens alors
lexception suivante :
35411 [2006-11-29 13:56:00,388] [org.jahia.bin.Jahia] ERROR - Error during
initialization of Jahia
org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could
not execute query; bad SQL grammar [select jahiasite0_.id_jahia_sites as
id1_, jahiasite0_.title_jahia_sites as title2_46_,
jahiasite0_.servername_jahia_sites as servername3_46_,
jahiasite0_.key_jahia_sites as key4_46_, jahiasite0_.active_jahia_sites as
active5_46_, jahiasite0_.defaultpageid_jahia_sites as defaultp6_46_,
jahiasite0_.defaulttemplateid_jahia_sites as defaultt7_46_,
jahiasite0_.tpl_deploymode_jahia_sites as tpl8_46_,
jahiasite0_.webapps_deploymode_jahia_sites as webapps9_46_,
jahiasite0_.rights_jahia_sites as rights10_46_,
jahiasite0_.descr_jahia_sites as descr11_46_,
jahiasite0_.default_site_jahia_sites as default12_46_ from jahia_sites
jahiasite0_]; nested exception is java.sql.SQLException: ORA-00904:
"JAHIASITE0_"."DEFAULT_SITE_JAHIA_SITES": invalid identifier
java.sql.SQLException: ORA-00904: "JAHIASITE0_"."DEFAULT_SITE_JAHIA_SITES":
invalid identifier
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:21
6)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatem
ent.java:799)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java
:1039)
at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStat
ement.java:839)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1132)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedSta
tement.java:3285)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatem
ent.java:3329)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingP
reparedStatement.java:92)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
at org.hibernate.loader.Loader.doQuery(Loader.java:391)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.ja
va:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at
org.springframework.orm.hibernate3.HibernateTemplate$29.doInHibernate(Hibern
ateTemplate.java:751)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTempla
te.java:312)
at
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.
java:742)
at
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.
java:734)
at
org.jahia.hibernate.dao.JahiaSiteDAO.getSites(JahiaSiteDAO.java:50)
at
org.jahia.hibernate.manager.JahiaSiteManager.getSites(JahiaSiteManager.java:
104)
at
org.jahia.hibernate.manager.JahiaSiteManager$$FastClassByCGLIB$$1ec2bf09.inv
oke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invok
eJoinpoint(Cglib2AopProxy.java:661)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:122)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(Tr
ansactionInterceptor.java:57)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:144)
at
org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(Abstract
TraceInterceptor.java:80)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:144)
at
org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInter
ceptor.intercept(Cglib2AopProxy.java:546)
at
org.jahia.hibernate.manager.JahiaSiteManager$$EnhancerByCGLIB$$66391716.getS
ites(<generated>)
at
org.jahia.services.sites.JahiaSitesBaseService.loadSitesInCache(JahiaSitesBa
seService.java:382)
at
org.jahia.services.sites.JahiaSitesBaseService.start(JahiaSitesBaseService.j
ava:169)
at
org.jahia.services.sites.JahiaSitesBaseService$$FastClassByCGLIB$$4d40271e.i
nvoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invok
eJoinpoint(Cglib2AopProxy.java:661)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:122)
at
org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(Abstract
TraceInterceptor.java:80)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:144)
at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.i
ntercept(Cglib2AopProxy.java:606)
at
org.jahia.services.sites.JahiaSitesBaseService$$EnhancerByCGLIB$$e79403cb.st
art(<generated>)
at
org.jahia.registries.ServicesRegistry.initService(ServicesRegistry.java:581)
at
org.jahia.registries.ServicesRegistry.init(ServicesRegistry.java:256)
at org.jahia.bin.Jahia.initServicesRegistry(Jahia.java:1144)
at org.jahia.bin.Jahia.init(Jahia.java:461)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:11
05)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:
3917)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4201)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:7
59)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:608)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535
)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
at
org.apache.catalina.startup.HostConfig.check(HostConfig.java:1190)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:292)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:119)
at
org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:
1305)
at
org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processC
hildren(ContainerBase.java:1569)
at
org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processC
hildren(ContainerBase.java:1578)
at
org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(Cont
ainerBase.java:1558)
at java.lang.Thread.run(Thread.java:595)
35416 [2006-11-29 13:56:00,393]
[org.jahia.services.database.ConnectionDispenser] INFO - abortConnection :
null
35417 [2006-11-29 13:56:00,394]
[org.jahia.services.database.ConnectionDispenser] INFO - abortConnection :
null
35418 [2006-11-29 13:56:00,395]
[org.jahia.services.database.ConnectionDispenser] INFO - abortConnection :
null
35418 [2006-11-29 13:56:00,395]
[org.jahia.services.database.ConnectionDispenser] INFO - abortConnection :
null
46309 [2006-11-29 13:56:11,286] [org.jahia.bin.Jahia] ERROR - INIT ERROR.
Jahia is not started.
46322 [2006-11-29 13:56:11,299]
[org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/jahia]]
INFO - Your Jahia Server has generated an error. Please review the details
below for additional information:
Error : Hibernate operation: could not execute query; bad SQL grammar
[select jahiasite0_.id_jahia_sites as id1_, jahiasite0_.title_jahia_sites as
title2_46_, jahiasite0_.servername_jahia_sites as servername3_46_,
jahiasite0_.key_jahia_sites as key4_46_, jahiasite0_.active_jahia_sites as
active5_46_, jahiasite0_.defaultpageid_jahia_sites as defaultp6_46_,
jahiasite0_.defaulttemplateid_jahia_sites as defaultt7_46_,
jahiasite0_.tpl_deploymode_jahia_sites as tpl8_46_,
jahiasite0_.webapps_deploymode_jahia_sites as webapps9_46_,
jahiasite0_.rights_jahia_sites as rights10_46_,
jahiasite0_.descr_jahia_sites as descr11_46_,
jahiasite0_.default_site_jahia_sites as default12_46_ from jahia_sites
jahiasite0_]; nested exception is java.sql.SQLException: ORA-00904:
"JAHIASITE0_"."DEFAULT_SITE_JAHIA_SITES": invalid identifier
Cette population des tables (et leur création) se fait-elle par les scripts
(ceux de var/db/sql) ou ailleurs ?
Cordialement,
Alexis Annosse
Smile - Motoristes Internet
<http://www.Smile.fr> www.Smile.fr
Tél : 01 41 40 88 02
