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)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Atlassian JIRA by Jeff Turner, 1 year ago
via Atlassian JIRA by Jeff Turner, 1 year ago
via struts-user by David Farrell, 1 year ago
org/apache/commons/logging/LogFactory >> at >> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:498) >> >> at org.apache.jsp.index_jsp._jspService(index_jsp.java:60)
via Oracle Community by 3004, 1 year ago
Servlet class: jhtmlc.test could not be > handled > by the ClassLoader > at > weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubI > mpl.java, Compiled Code) > at > weblogic.servlet.internal.ServletStubImpl.getServlet
via Google Groups by sammer, 2 years ago
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)
via java.net by Unknown author, 2 years ago
Servlet execution threw an exception at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:313) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206
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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago

Know the solutions? Share your knowledge to help other developers to debug faster.