HTTP Status 500 – Internal Server Error


Type Exception Report

Message org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT * FROM user us WHERE us.uuid = ?]; nested exception is java.sql.SQLSyntaxErrorException: Table 'ca6.user' doesn't exist

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

Exception

org.apache.jasper.JasperException: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT * FROM user us WHERE us.uuid = ?]; nested exception is java.sql.SQLSyntaxErrorException: Table 'ca6.user' doesn't exist
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:598)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:514)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.gotapi.ca.plain.server.MyFilter.doFilter(MyFilter.java:79)

Root Cause

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT * FROM user us WHERE us.uuid = ?]; nested exception is java.sql.SQLSyntaxErrorException: Table 'ca6.user' doesn't exist
	org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:235)
	org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1443)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:783)
	com.gotapi.ca.plain.server.github.dao.JdbcTemplateGitUser.getUserFromUuid(JdbcTemplateGitUser.java:45)
	org.apache.jsp.index_jsp._jspService(index_jsp.java:207)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.gotapi.ca.plain.server.MyFilter.doFilter(MyFilter.java:79)

Root Cause

java.sql.SQLSyntaxErrorException: Table 'ca6.user' doesn't exist
	com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
	com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
	org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:678)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:783)
	com.gotapi.ca.plain.server.github.dao.JdbcTemplateGitUser.getUserFromUuid(JdbcTemplateGitUser.java:45)
	org.apache.jsp.index_jsp._jspService(index_jsp.java:207)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.gotapi.ca.plain.server.MyFilter.doFilter(MyFilter.java:79)

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


Apache Tomcat/8.5.41