HTTP Status 500 – Internal Server Error


Type Exception Report

Message java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-16, 16' at line 1

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

Exception

javax.servlet.ServletException: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-16, 16' at line 1
	pvgoran.servlet.subjectdriven.SubjectDrivenServletBase.service(SubjectDrivenServletBase.java:192)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)

Root Cause

java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-16, 16' at line 1
	com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
	com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
	com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
	sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118)
	com.sun.proxy.$Proxy14.executeQuery(Unknown Source)
	pvgoran.dataaccess.query.ObjectSelectQuery.selectObjectList(ObjectSelectQuery.java:77)
	logic.dao.NodeDAO.getUniversalNodes(NodeDAO.java:243)
	ktvapp.subject.BestNodesSubject$DefaultWorker.run(BestNodesSubject.java:93)
	pvgoran.servlet.subjectdriven.SubjectDrivenServletBase.service(SubjectDrivenServletBase.java:167)
	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.75