Re: How to make Jahia 5.0.2 running with oracle 10g XE ?

Which portlet are you using? The Html clip portlet or the Sql clip portlet?
When does this problem occur?

Best regards,
Damien Saulnier


DELSAUX Jean-Michel a écrit :
>
> Try to use Jahia 5.0.2 running with Oracle XE 10g.
>
>  
>
> Install with no error ...  No missing tables as in 5.0.1_03.
>
>  
>
> Now, there is oracle error when using clip portlet (see below).
>
>  
>
> Can we use Oracle with Jahia ?????  Is there a solution ?????
>
>  
>
>  
>
> 2007-07-25 09:28:23,299: INFO  [deployment] - Loading 
> web.xml....jahia_clip_SNCB
>
>  Clip
>
> 2007-07-25 09:28:24,112: ERROR [deployment] - Failed to register 
> portlet applica
>
> tion, jahia_clip_SNCB Clip
>
> org.springframework.dao.DataIntegrityViolationException: (OJB 
> operation): data i
>
> ntegrity violated by SQL ''; nested exception is 
> java.sql.SQLException: ORA-0140
>
> 0: impossible d'insÚrer NULL dans 
> ("USER_JAHIAV502"."LOCALIZED_DESCRIPTION"."DES
>
> CRIPTION")
>
>  
>
> java.sql.SQLException: ORA-01400: impossible d'insÚrer NULL dans 
> ("USER_JAHIAV50
>
> 2"."LOCALIZED_DESCRIPTION"."DESCRIPTION")
>
>  
>
>         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:216)
>
>         at 
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedSta
>
> tement.java:955)
>
>         at 
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
>
> nt.java:1168)
>
>         at 
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
>
> aredStatement.java:3285)
>
>         at 
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
>
> edStatement.java:3368)
>
>         at 
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del
>
> egatingPreparedStatement.java:102)
>
>         at 
> org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAc
>
> cessImpl.java:216)
>
>         at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Persistenc
>
> eBrokerImpl.java:1754)
>
>         at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBro
>
> kerImpl.java:813)
>
>         at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBro
>
> kerImpl.java:726)
>
>         at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeAndLinkOneToMan
>
> y(PersistenceBrokerImpl.java:1057)
>
>         at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollections(Per
>
> sistenceBrokerImpl.java:928)
>
>         at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Persistenc
>
> eBrokerImpl.java:1776)
>
>         at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBro
>
> kerImpl.java:813)
>
>         at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBro
>
> kerImpl.java:726)
>
>         at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeAndLinkOneToMan
>
> y(PersistenceBrokerImpl.java:1057)
>
>         at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeCollections(Per
>
> sistenceBrokerImpl.java:928)
>
>         at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Persistenc
>
> eBrokerImpl.java:1776)
>
>         at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBro
>
> kerImpl.java:813)
>
>         at 
> org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBro
>
> kerImpl.java:726)
>
>         at 
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegati
>
> ngPersistenceBroker.java:175)
>
>         at 
> org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Delegati
>
> ngPersistenceBroker.java:175)
>
>         at 
> org.springframework.orm.ojb.PersistenceBrokerTemplate$9.doInPersisten
>
> ceBroker(PersistenceBrokerTemplate.java:237)
>
>         at 
> org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(Persist
>
> enceBrokerTemplate.java:137)
>
>         at 
> org.springframework.orm.ojb.PersistenceBrokerTemplate.store(Persisten
>
> ceBrokerTemplate.java:235)
>
>         at 
> org.apache.jetspeed.components.portletregistry.PersistenceBrokerPortl
>
> etRegistry.registerPortletApplication(PersistenceBrokerPortletRegistry.java:203)
>
>  
>
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
>         at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
>
> java:39)
>
>         at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
>
> sorImpl.java:25)
>
>         at java.lang.reflect.Method.invoke(Method.java:585)
>
>         at 
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
>
> on(AopUtils.java:288)
>
>         at 
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
>
> inpoint(ReflectiveMethodInvocation.java:155)
>
>         at 
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>
> ReflectiveMethodInvocation.java:122)
>
>         at 
> org.springframework.transaction.interceptor.TransactionInterceptor.in
>
> voke(TransactionInterceptor.java:57)
>
>         at 
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>
> ReflectiveMethodInvocation.java:144)
>
>         at 
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
>
> cAopProxy.java:174)
>
>         at $Proxy0.registerPortletApplication(Unknown Source)
>
>         at 
> org.apache.jetspeed.tools.pamanager.PortletApplicationManager.registe
>
> rPortletApplication(PortletApplicationManager.java:334)
>
>         at 
> org.apache.jetspeed.tools.pamanager.PortletApplicationManager.startPA
>
> (PortletApplicationManager.java:446)
>
> ...
>
>  
>
>  
>
>  
>
> -------------------------------------------------------------------------------------------------------------
> Jean-Michel Delsaux - N.R.B.         mailto:[email protected]
> Tel: +32 4 249 7046  -   GSM: +32 476 961 519
> 2eme Avenue, 65   -   P.I. Hauts Sarts   -   B-4040 HERSTAL (BELGIQUE)
>
>  
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> install_list mailing list
> [email protected]
> http://lists.jahia.org/cgi-bin/mailman/listinfo/install_list
>   

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