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 1
   from g_foot f, st_pointfromtext('POINT( )', 3034) p2
   where f.g_foot_ertslcc && p2
      and f.g_unit = 10090283
: ERROR: parse error - invalid geometry
  Hint: "POINT( )" <-- parse error at position 9 within geometry
  Where: SQL function "st_pointfromtext" statement 1
	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 1
   from g_foot f, st_pointfromtext('POINT( )', 3034) p2
   where f.g_foot_ertslcc && p2
      and f.g_unit = 10090283
: ERROR: parse error - invalid geometry
  Hint: "POINT( )" <-- parse error at position 9 within geometry
  Where: SQL function "st_pointfromtext" statement 1
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:652)
	org.apache.jsp.place.place_005flinks_jsp._jspService(place_005flinks_jsp.java:434)
	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: parse error - invalid geometry
  Hint: "POINT( )" <-- parse error at position 9 within geometry
  Where: SQL function "st_pointfromtext" statement 1
	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_005flinks_jsp._jspx_meth_sql_005fquery_005f1(place_005flinks_jsp.java:597)
	org.apache.jsp.place.place_005flinks_jsp._jspService(place_005flinks_jsp.java:189)
	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