16 May
2007
16 May
'07
5:11 p.m.
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@massol.net]
Sent: 16 May 2007 04:45 PM
To: xwiki-dev(a)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(a)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