Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-5828

Bugzilla search portlet fails when using MSSQL database

    XMLWordPrintable

Details

    Description

      A user reports the the Bugzilla ID search portlet fails when using SQL Server:

      javax.servlet.ServletException: SQL Exception while executing the
      following:SELECT ID, groupid, FIELDTYPE, FIELD, OLDVALUE, OLDSTRING,
      NEWVALUE, NEWSTRING FROM changeitem WHERE FIELD=? AND OLDSTRING=? ORDER
      BY groupid desc (The text, ntext, and image data types cannot be
      compared or sorted, except when using IS NULL or LIKE operator.)
      at
      org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageCont
      extImpl.java:867)
      at
      org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContex
      tImpl.java:800)
      at
      org.apache.jsp.bugzillasearch_jsp._jspService(bugzillasearch_jsp.java:86
      )
      at
      org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at
      org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja
      va:311)
      at
      org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
      at
      org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at
      org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
      tionFilterChain.java:284)
      at
      ....

      Attachments

        1. bugzillasearch.jsp
          2 kB
          Jeff Turner

        Activity

          People

            7ee5c68a815f Jeff Turner
            7ee5c68a815f Jeff Turner
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: