HTTP Status 500 – Internal Server Error


Type Exception Report

Message org.hibernate.exception.SQLGrammarException: could not execute query

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.apache.jasper.JasperException: org.hibernate.exception.SQLGrammarException: could not execute query
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:638)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:514)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	com.encima.fw.filters.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:55)
	com.encima.fw.filters.WebLangFilter.doFilter(WebLangFilter.java:46)
	com.encima.fw.filters.RequestLoggingFilter.doFilter(RequestLoggingFilter.java:70)
	com.encima.fw.filters.UTF8Filter.doFilter(UTF8Filter.java:53)

Root Cause

org.hibernate.exception.SQLGrammarException: could not execute query
	org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
	org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	org.hibernate.loader.Loader.doList(Loader.java:2536)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
	org.hibernate.loader.Loader.list(Loader.java:2271)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
	org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
	org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
	org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	org.apache.jsp.artist_jsp._jspService(artist_jsp.java:199)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	com.encima.fw.filters.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:55)
	com.encima.fw.filters.WebLangFilter.doFilter(WebLangFilter.java:46)
	com.encima.fw.filters.RequestLoggingFilter.doFilter(RequestLoggingFilter.java:70)
	com.encima.fw.filters.UTF8Filter.doFilter(UTF8Filter.java:53)

Root Cause

org.postgresql.util.PSQLException: ERROR: operator does not exist: character = bytea
  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
  Position: 1213
	org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
	org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
	org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
	org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
	org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
	org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
	org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116)
	org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
	org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
	org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
	org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
	org.hibernate.loader.Loader.doQuery(Loader.java:802)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
	org.hibernate.loader.Loader.doList(Loader.java:2533)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
	org.hibernate.loader.Loader.list(Loader.java:2271)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
	org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
	org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
	org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	org.apache.jsp.artist_jsp._jspService(artist_jsp.java:199)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	com.encima.fw.filters.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:55)
	com.encima.fw.filters.WebLangFilter.doFilter(WebLangFilter.java:46)
	com.encima.fw.filters.RequestLoggingFilter.doFilter(RequestLoggingFilter.java:70)
	com.encima.fw.filters.UTF8Filter.doFilter(UTF8Filter.java:53)

Note The full stack trace of the root cause is available in the server logs.


Apache Tomcat/9.0.26