Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-3545

Group Administration breaks when connected to a DB2 database

    XMLWordPrintable

    Details

    • 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)

        Attachments

          Activity

            People

            Assignee:
            sdumitriu Sergiu Dumitriu
            Reporter:
            bindul Bindul Bhowmik
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Date of First Response: