HTTP Status 500 – Internal Server Error


Type Exception Report

Message javax.servlet.ServletException: javax.servlet.jsp.JspException:

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

Exception

org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException:   
   SELECT   g_name,
      util.pretty_name(g_name) as pretty_name,
      g_container as county,
      is_county,
      is_district,
      is_nation,
      is_state,
      is_domain,
      nation_name,
      state_name,
      domain_name,
      county_name,
      g_county,
      g_nation,
      g_state,
      g_domain,
      mod_dist,
      district_name,
      district_type,
      substr(district_name, 1, length(county_name)) as dist_start,
      substr(district_name, length(district_name) - length(county_name)+1) as dist_end,
      tt_count,
      dg_text_ID,
      dg_text_auth,
      dg_text,
      position('. ' in substr(dg_text, 301))+301 as dg_breakpoint,
      has_multiple_names,
      see_also_place,
      round(st_x(g_point)::numeric, 5) as x, 
      round(st_y(g_point)::numeric, 5) as y,
      round(st_x(ST_Transform(g_point, 4326))::numeric, 5) as lon,
      round(st_y(ST_Transform(g_point, 4326))::numeric, 5) as lat,
      round(st_x(g_point_uk)::numeric, 5) as x_osgb,
      round(st_y(g_point_uk)::numeric, 5) as y_osgb,
      g_point_auth,
      notes
   FROM g_place
   WHERE g_place = ?::integer 
    
: ERROR: invalid input syntax for type integer: "xxxx"
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:623)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:489)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)

Root Cause

javax.servlet.ServletException: javax.servlet.jsp.JspException:   
   SELECT   g_name,
      util.pretty_name(g_name) as pretty_name,
      g_container as county,
      is_county,
      is_district,
      is_nation,
      is_state,
      is_domain,
      nation_name,
      state_name,
      domain_name,
      county_name,
      g_county,
      g_nation,
      g_state,
      g_domain,
      mod_dist,
      district_name,
      district_type,
      substr(district_name, 1, length(county_name)) as dist_start,
      substr(district_name, length(district_name) - length(county_name)+1) as dist_end,
      tt_count,
      dg_text_ID,
      dg_text_auth,
      dg_text,
      position('. ' in substr(dg_text, 301))+301 as dg_breakpoint,
      has_multiple_names,
      see_also_place,
      round(st_x(g_point)::numeric, 5) as x, 
      round(st_y(g_point)::numeric, 5) as y,
      round(st_x(ST_Transform(g_point, 4326))::numeric, 5) as lon,
      round(st_y(ST_Transform(g_point, 4326))::numeric, 5) as lat,
      round(st_x(g_point_uk)::numeric, 5) as x_osgb,
      round(st_y(g_point_uk)::numeric, 5) as y_osgb,
      g_point_auth,
      notes
   FROM g_place
   WHERE g_place = ?::integer 
    
: ERROR: invalid input syntax for type integer: "xxxx"
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:652)
	org.apache.jsp.place.place_005fpage_jsp._jspService(place_005fpage_jsp.java:618)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)

Root Cause

org.postgresql.util.PSQLException: ERROR: invalid input syntax for type integer: "xxxx"
	org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
	org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
	org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
	org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
	org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161)
	org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
	jdk.internal.reflect.GeneratedMethodAccessor174.invoke(Unknown Source)
	java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.base/java.lang.reflect.Method.invoke(Method.java:566)
	org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118)
	com.sun.proxy.$Proxy163.executeQuery(Unknown Source)
	org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTagSupport.java:224)
	org.apache.jsp.place.place_005fpage_jsp._jspx_meth_sql_005fquery_005f0(place_005fpage_jsp.java:962)
	org.apache.jsp.place.place_005fpage_jsp._jspService(place_005fpage_jsp.java:307)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:466)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)

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


Apache Tomcat/9.0.82