16 May
2007
16 May
'07
4:44 p.m.
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
16 May
16 May
5:11 p.m.
New subject: [xwiki-dev] xwiki on oracle 9
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
24 May
24 May
2:40 p.m.
New subject: [xwiki-dev] xwiki on oracle 9
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(a)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@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:
--
Ludovic Dubost
Blog: http://www.ludovic.org/blog/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost
AIM: nvludo Yahoo: ludovic
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(a)objectweb.org mailing list.
To unsubscribe: mailto:xwiki-dev-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
6378
days inactive
6386
days old
2 comments
3 participants
participants (3)
-
Ludovic Dubost -
Vincent Massol -
yeboaher＠telkom.co.za