Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-8588

Encoding Test Fails on DB2

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Low Low
    • None
    • 2.3
    • None

      An error occurs when running the encoding test when using DB2.

      com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: LOWER;FUNCTION
      at com.ibm.db2.jcc.b.id.e(id.java:1640)
      at com.ibm.db2.jcc.b.id.a(id.java:1229)
      at com.ibm.db2.jcc.c.fb.h(fb.java:149)
      at com.ibm.db2.jcc.c.fb.a(fb.java:43)
      at com.ibm.db2.jcc.c.s.a(s.java:30)
      at com.ibm.db2.jcc.c.wb.g(wb.java:152)
      at com.ibm.db2.jcc.b.id.n(id.java:1209)
      at com.ibm.db2.jcc.b.id.a(id.java:1889)
      at com.ibm.db2.jcc.b.id.a(id.java:517)
      at com.ibm.db2.jcc.b.id.executeQuery(id.java:501)
      at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)
      at com.atlassian.confluence.admin.actions.debug.EncodingTestAction.retrieveLowerDatabaseTestString(EncodingTestAction.java:117)

      The IBM Documentation on the LOWER function says:
      > The argument must be an expression whose value is a CHAR or VARCHAR data type.

      Looks like DB2 doesn't support LOWER on a BLOB

            [CONFSERVER-8588] Encoding Test Fails on DB2

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2901464 ] New: CONFSERVER Bug Workflow v4 [ 2996115 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2797704 ] New: JAC Bug Workflow v3 [ 2901464 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2727836 ] New: JAC Bug Workflow v2 [ 2797704 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2392652 ] New: JAC Bug Workflow [ 2727836 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2274951 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2392652 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2233010 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2274951 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2193690 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2233010 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1912969 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2193690 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1719510 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1912969 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Bug Subtask WF (TEMP) [ 1696991 ] New: Confluence Workflow - Public Facing - Restricted v3 [ 1719510 ]

              Unassigned Unassigned
              mjensen m@ (Inactive)
              Affected customers:
              0 This affects my team
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: