Well, In your case, you have to check if the description is empty and set a default description to avoid that problem, haven't you ? Or, set it as mandatory.
I just test it and it's OK :-) Thanks JMi -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Damien Sent: lundi 30 juillet 2007 16:41 To: In this list you can send questions and discuss installation problems aswell as suggest installation improvements. Subject: Re: [install_list] How to make Jahia 5.0.2 running with oracle 10g XE ? Hello, This problem is due to the fact that the portlet trys to insert an empty string in a column with a not null constraint. Such operation is normally allowed, but it is not the case with Oracle. Indeed, an empty string is interpreted as null by Oracle. As the concerned table is automaticaly generated by jetspeed, we have no control on this constraint. So the only solution is to avoid inserting an empty string, what you can do in this case if you enter a description for the portlet. You can perform a search on the web about "ORA-01400", you will see that this behavior is problematic for many people. Best regards, Damien Saulnier DELSAUX Jean-Michel a écrit : > Html clip portlet > > It occurs when deploying ... > > Here is the log > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Damien > Sent: mercredi 25 juillet 2007 15:15 > To: In this list you can send questions and discuss installation problems > aswell as suggest installation improvements. > Subject: Re: [install_list] 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 > > ------------------------------------------------------------------------ > > _______________________________________________ > 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 _______________________________________________ install_list mailing list [email protected] http://lists.jahia.org/cgi-bin/mailman/listinfo/install_list
