Hi, We are working on fixing this issue which also exists in HSQLDB and Sybase. It should be ok in the next release. Ludovic
I'm interested in using XWIKI with a DB2 database back-end. I've had some success creating the DB2 schema, populating with data from the MySQL database supplied for xwiki v. 0.9.793. However, when I hit the following URL:
http://127.0.0.1:8080/xwiki/bin/view/Main/WebHome
DB2 doesn't like the following query, which is generated from XWikiHibernateStore starting on line 1775:
select distinct xwikidocum0_.XWD_WEB as col_0_0_, xwikidocum0_.XWD_NAME as col_1_0_ from xwikidoc xwikidocum0_, xwikiobjects baseobject1_ where baseobject1_.XWO_NAME=xwikidocum0_.XWD_FULLNAME and baseobject1_.XWO_CLASSNAME='XWiki.XWikiUsers' order by xwikidocum0_.XWD_CREATION_DATE desc
From reading the DB2 docs, I think DB2 doesn't permit use of a column in the order by clause that does not also appear in the select clause, if the distinct keyword is present. I was able to fix the problem by removing the word "distinct" from the query on line 1775 of XWikiHibernateStore. That allowed me to view the home page, and do several other tasks -- edit pages, attach documents, etc.
I don't know how critical that "distinct" is to the correct operation of xwiki. I was wondering if the developers could answer that. If "distinct" is not needed and can be removed, or the query can somehow be reworked then I will be glad to submit my DB2 schema on the Database Development page.
Stephen
-- Ludovic Dubost Blog: http://www.ludovic.org/blog/ Créez votre Wiki: http://www.xwiki.com XPertNet: http://www.xpertnet.fr