Details
-
Bug
-
Resolution: Fixed
-
Major
-
1.7.2, 1.8 RC1, 1.8 RC2, 1.8
-
None
-
Xwiki Enterprise running against DB2
-
db2, admin, group
-
Description
When a xwiki instance is brought up against a DB2 database, the Groups administration page breaks. In the logs there is a DB exception shown below:
02:17:59,892 http://hubwiki.tvlport.com/bin/admin/XWiki/XWikiPreferences?xpage=getgroups&offset=1&limit=15&reqNo=4&wiki=local [http-18080-2] DEBUG util.JDBCExceptionReporter - could not execute query [select stringprop2_.XWS_VALUE as col_0_0_ from HUBXWIKI.xwikidoc xwikidocum0_, HUBXWIKI.xwikiobjects baseobject1_, HUBXWIKI.xwikistrings stringprop2_ inner join HUBXWIKI.xwikiproperties stringprop2_1_ on stringprop2_.XWS_ID=stringprop2_1_.XWP_ID and stringprop2_.XWS_NAME=stringprop2_1_.XWP_NAME where xwikidocum0_.XWD_FULLNAME=? and xwikidocum0_.XWD_FULLNAME=baseobject1_.XWO_NAME and baseobject1_.XWO_CLASSNAME=? and baseobject1_.XWO_ID=stringprop2_.XWS_ID and (ltrim( rtrim( stringprop2_.XWS_VALUE ) )<>? or (ltrim( rtrim( stringprop2_.XWS_VALUE ) ) is not null) and (? is null))]
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null
at com.ibm.db2.jcc.b.hh.c(hh.java:1662)