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)

Atlassian JIRA | Jeff Turner | 1 decade ago
  1. 0

    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 ....

    Atlassian JIRA | 1 decade ago | Jeff Turner
    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)
  2. 0

    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 ....

    Atlassian JIRA | 1 decade ago | Jeff Turner
    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)
  3. 0

    HTTPServlet error in runttime

    Stack Overflow | 6 years ago | Jose Hdez
    javax.servlet.ServletException: non-HTTP request or response
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Tomcat JDBC error

    Google Groups | 1 decade ago | sammer
    javax.servlet.ServletException: oracle.jdbc.driver.OracleDriver at org.apache.jasper.runtime.PageContextImpl.handlePageExceptio- n(PageContextImpl.java:533) at org.apache.jsp.Jdbccode_jsp._jspService(Jdbccode_jsp.java:105) .java:137)

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame