DELSAUX Jean-Michel a écrit : > Well, > Hi > In your case, you have to check if the description is empty and set a default > description to avoid that problem, haven't you ? The test of "not null description" is done in jahia. If description is null, we set it to "" (empty string). Unfortatly, Oracle assumes that "" (empty string) is same as null value... wich is wronng :-).
http://jeffkemponoracle.blogspot.com/2006/02/empty-string-andor-null.html http://opensource.atlassian.com/projects/hibernate/browse/HV-13 (last thread) Regards, KT. > 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 > > _______________________________________________ install_list mailing list [email protected] http://lists.jahia.org/cgi-bin/mailman/listinfo/install_list
