[xwiki-dev] xwiki on oracle 9

[Ludovic Dubost]

You might want to use xwiki.backlinks=0 to test further..
And also send the rest of the stack trace as it doesn't show the real 
error here

Ludovic

yeboaher at telkom.co.za a écrit :
> Thanks Vincent,
>
> There are subtle differences between Oracle XE and Oracle 9.
> This is to do with how they treat CLOBS.
> I have followed the instructions for 10g / XE.
> hibernate.hbm.xml settings are (XXXs are for security reasons. But I had correct details) Also, I added the JdbcOraWrapper.jar into xwiki\WEB-INF\lib:
>
> <property name="connection.url">jdbc:oracle_clob:thin:@xxxxxx:1527:XXXX</property>
> <property name="connection.username">xxxxx</property>
> <property name="connection.password">yyyy</property>
> <property name="connection.driver_class">JdbcOraWrapperDriver</property>
> <!--property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property-->
> <property name="dialect">org.hibernate.dialect.OracleDialect</property>
> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
> <property name="connection.pool_size">2</property>
> <property name="statement_cache.size">2</property>
>
> <mapping resource="xwiki.oracle.hbm.xml"/>
> <mapping resource="feeds.oracle.hbm.xml"/>
>
>
>
> Below is the stack trace:
> -------------------------------------------------------------------------------
> com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
> Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences
> Wrapped Exception: Error number 13012 in 3: Exception while saving links
> Wrapped Exception: null
> 	at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:291)
> 	at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:383)
> 	at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96)
> 	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
> 	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
> 	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
> 	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> 	at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1077)
> 	at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:465)
> 	at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
> 	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
> 	at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:118)
> 	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
> 	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:7053)
> 	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
> 	at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
> 	at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3902)
> 	at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2773)
> 	at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
> 	at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
>
> -------------------------------------------------------------------------------
>
> Thanks.
> Ed
>
>
> -----Original Message-----
> From: Vincent Massol [mailto:vincent at massol.net] 
> Sent: 16 May 2007 04:45 PM
> To: xwiki-dev at objectweb.org
> Cc: Edward Yeboah (R)
> Subject: Re: [xwiki-dev] xwiki on oracle 9
>
> Hi Ed,
>
> As you told me in a separate conversation you forgot to send this email below to the list so I'm answering there.
>
> see my answers below.
>
> On May 16, 2007, at 4:27 PM, yeboaher at telkom.co.za wrote:
>
>   
>> Well, IMHO, it is seriously unfunctional.
>>
>> We are compared several wikis and unanimously agreed that xwiki 
>> offered what we're looking for on wikis.
>> I was tasked to implement.
>> However, our preferred standard is WebLogic 8.5/6 and Oracle 9 on 
>> HPUX.
>>
>> I've tried to install on both windows and HPUX and get the same series 
>> of errors are reported in several of the newsgroups/forums. :>
>>
>> It became clear that there are several issues with Oracle 9 and Oracle 
>> 10.
>> Some dating back to mid-2006
>>
>> The first problem was creating the oracle tables with CLOBS.
>> I solved this by using a wrapper driver class. This was downloaded
>> from:
>> http://l3x.net/imwiki/Wiki.jsp?page=JdbcOraWrapper
>>
>> The tables were created and next, loading of the default data.
>> On trying to initialise the wiki context, this error occurred:
>> java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into
>> ("D_YEBOAHER_9"."XWIKIDOC"."XWD_ARCHIVE")
>> Apparently, Oracle 9 translates "" empty string to nulls.
>> Therefore a not-null column exhibits this problem.
>>
>> Whilst searching the forums, I found another error in the forum that 
>> we are yet to face.
>> This error is to do with the search engine and how only the first 4k 
>> of a page is searched.
>> This issue is also caused by Hibernate's use of Oracle CLOBS.
>>
>> As I see it, the issue is to do with the Hibernate aspect of the 
>> application.
>>
>> Unless I have missed something stupidly simple, I cannot resolve the 
>> issue without the source code.
>>     
>
> What version of XWiki are you using? AFAIK the oracle supports is working fine since 1.0 RC1 (I do know several users working happily with Oracle and XWiki). If you're using some old version I'd suggest you try with RC4.
>
> Now Oracle support has been tested only on Oracle Express 10g (see http://www.xwiki.org/xwiki/bin/view/AdminGuide/InstallationOracle),
> so maybe there's an issue there.
>
> Of course it's possible that there are still issues even on RC4. We would love to know about them and even better work with you to fix them.
>
> Thanks a lot
> -Vincent
>
>
>   
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the xwiki-dev at objectweb.org mailing list.
> To unsubscribe: mailto:xwiki-dev-unsubscribe at objectweb.org
> For general help: mailto:sympa at objectweb.org?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>   


-- 
Ludovic Dubost
Blog: http://www.ludovic.org/blog/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost 
AIM: nvludo Yahoo: ludovic