Re: [xwiki-dev] xwiki on oracle 9

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.