HTTP Status 500 - Unable to compile class for JSP:


type Exception report

message Unable to compile class for JSP:

description The server encountered an internal error that prevented it from fulfilling this request.

exception

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

An error occurred at line: 27 in the jsp file: /jspResources/imprimir_cobertura.jsp
sqlQuery cannot be resolved to a variable
24:         String auditoriaTexto = laRuta;
25:         String auditoriaTipo = "L";
26: 
27:         sqlQuery = " INSERT INTO LITI.AUDITORIAS (AUDITORIA_ID, AUDITORIA_USUARIO, AUDITORIA_TIPO, AUDITORIA_FECHA, AUDITORIA_SUCESO, AUDITORIA_TEXTO) VALUES (SQ_AUDITORIAS.NEXTVAL, '"+session.getAttribute("usuario")+"', '"+auditoriaTipo+"', SYSDATE, '"+audit+"', '" + auditoriaTexto.replaceAll("'", "''") + "')";
28:         st2.executeUpdate(sqlQuery);
29:     } 
30:     catch (Exception z) {


An error occurred at line: 28 in the jsp file: /jspResources/imprimir_cobertura.jsp
st2 cannot be resolved
25:         String auditoriaTipo = "L";
26: 
27:         sqlQuery = " INSERT INTO LITI.AUDITORIAS (AUDITORIA_ID, AUDITORIA_USUARIO, AUDITORIA_TIPO, AUDITORIA_FECHA, AUDITORIA_SUCESO, AUDITORIA_TEXTO) VALUES (SQ_AUDITORIAS.NEXTVAL, '"+session.getAttribute("usuario")+"', '"+auditoriaTipo+"', SYSDATE, '"+audit+"', '" + auditoriaTexto.replaceAll("'", "''") + "')";
28:         st2.executeUpdate(sqlQuery);
29:     } 
30:     catch (Exception z) {
31: 												//out.print("Auditoria Inservible: " + z.getMessage());


An error occurred at line: 28 in the jsp file: /jspResources/imprimir_cobertura.jsp
sqlQuery cannot be resolved to a variable
25:         String auditoriaTipo = "L";
26: 
27:         sqlQuery = " INSERT INTO LITI.AUDITORIAS (AUDITORIA_ID, AUDITORIA_USUARIO, AUDITORIA_TIPO, AUDITORIA_FECHA, AUDITORIA_SUCESO, AUDITORIA_TEXTO) VALUES (SQ_AUDITORIAS.NEXTVAL, '"+session.getAttribute("usuario")+"', '"+auditoriaTipo+"', SYSDATE, '"+audit+"', '" + auditoriaTexto.replaceAll("'", "''") + "')";
28:         st2.executeUpdate(sqlQuery);
29:     } 
30:     catch (Exception z) {
31: 												//out.print("Auditoria Inservible: " + z.getMessage());


Stacktrace:
	org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:102)
	org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:331)
	org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:468)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:378)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:353)
	org.apache.jasper.compiler.Compiler.compile(Compiler.java:340)
	org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:646)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:357)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.35 logs.


Apache Tomcat/7.0.35