9 Jun
2005
9 Jun
'05
4:45 p.m.
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