Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.7.2, 1.8 RC1, 1.8 RC2, 1.8
-
Component/s: {Unused} Authentication and Rights Management
-
Labels:None
-
Environment:Xwiki Enterprise running against DB2
-
keywords:db2, admin, group
-
Similar issues:
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)