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: [37] in the jsp file: [/footer.jsp]
Statement cannot be resolved to a type
34:                   try {
35: 
36: 	  
37: 	            Statement statement = connection.createStatement();
38:                   ResultSet rs =statement.executeQuery("SELECT  DISTINCT (`pdt_cat3`) FROM `user_products` WHERE `user_name`='"+user+"' LIMIT 6");
39:                     while(rs.next()) {
40:     	


An error occurred at line: [37] in the jsp file: [/footer.jsp]
connection cannot be resolved
34:                   try {
35: 
36: 	  
37: 	            Statement statement = connection.createStatement();
38:                   ResultSet rs =statement.executeQuery("SELECT  DISTINCT (`pdt_cat3`) FROM `user_products` WHERE `user_name`='"+user+"' LIMIT 6");
39:                     while(rs.next()) {
40:     	


An error occurred at line: [38] in the jsp file: [/footer.jsp]
ResultSet cannot be resolved to a type
35: 
36: 	  
37: 	            Statement statement = connection.createStatement();
38:                   ResultSet rs =statement.executeQuery("SELECT  DISTINCT (`pdt_cat3`) FROM `user_products` WHERE `user_name`='"+user+"' LIMIT 6");
39:                     while(rs.next()) {
40:     	
41:                 	   %> 


An error occurred at line: [38] in the jsp file: [/footer.jsp]
user cannot be resolved to a variable
35: 
36: 	  
37: 	            Statement statement = connection.createStatement();
38:                   ResultSet rs =statement.executeQuery("SELECT  DISTINCT (`pdt_cat3`) FROM `user_products` WHERE `user_name`='"+user+"' LIMIT 6");
39:                     while(rs.next()) {
40:     	
41:                 	   %> 


An error occurred at line: [276] in the jsp file: [/footer.jsp]
connection cannot be resolved
273:   captionText.innerHTML = dots[slideIndex-1].alt;
274: }
275: </script>
276: <%connection.close();%>
277: </body>
278: </html>
279:   


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:498)
	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.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:994)
	org.apache.jsp.gallery_jsp._jspService(gallery_jsp.java:171)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
	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: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.58