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@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
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@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@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 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@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@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@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@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
-- Ludovic Dubost Blog: http://www.ludovic.org/blog/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost AIM: nvludo Yahoo: ludovic
participants (3)
-
Ludovic Dubost -
Vincent Massol -
yeboaher＠telkom.co.za