HTTP Status 500 – Internal Server Error


Type Exception Report

Message Unable to compile class for JSP:

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

Exception

org.apache.jasper.JasperException: Unable to compile class for JSP: 

An error occurred at line: [13] in the jsp file: [/WEB-INF/view/products.jsp]
PreparedStatement cannot be resolved to a type
10:             <%  try
11:                 {
12:   
13:             PreparedStatement ps = connection.prepareStatement("SELECT pdt_img,pdt_name,pdt_url FROM user_products where  user_name='"+user+"' and status='Active'");   
14:                    ResultSet rs = ps.executeQuery();   
15:                     while(rs.next())      
16:                            {       


An error occurred at line: [13] in the jsp file: [/WEB-INF/view/products.jsp]
connection cannot be resolved
10:             <%  try
11:                 {
12:   
13:             PreparedStatement ps = connection.prepareStatement("SELECT pdt_img,pdt_name,pdt_url FROM user_products where  user_name='"+user+"' and status='Active'");   
14:                    ResultSet rs = ps.executeQuery();   
15:                     while(rs.next())      
16:                            {       


An error occurred at line: [13] in the jsp file: [/WEB-INF/view/products.jsp]
user cannot be resolved to a variable
10:             <%  try
11:                 {
12:   
13:             PreparedStatement ps = connection.prepareStatement("SELECT pdt_img,pdt_name,pdt_url FROM user_products where  user_name='"+user+"' and status='Active'");   
14:                    ResultSet rs = ps.executeQuery();   
15:                     while(rs.next())      
16:                            {       


An error occurred at line: [14] in the jsp file: [/WEB-INF/view/products.jsp]
ResultSet cannot be resolved to a type
11:                 {
12:   
13:             PreparedStatement ps = connection.prepareStatement("SELECT pdt_img,pdt_name,pdt_url FROM user_products where  user_name='"+user+"' and status='Active'");   
14:                    ResultSet rs = ps.executeQuery();   
15:                     while(rs.next())      
16:                            {       
17:                     %> 


Stacktrace:
	org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:102)
	org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:213)
	org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:487)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:397)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:367)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:351)
	org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:605)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:399)
	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:764)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:171)
	org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:316)
	org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1373)
	org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1118)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1057)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

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


Apache Tomcat/9.0.52