Hello Sir,
I followed ur tutorial entitled "Display Sum Of table using in jsp" but it comes out with following error while showing the total salary .any help will be heartly appreciated.Entering salary is working fine.thnx
Connected to the database
query select sum(emp_salary) from sumcount where date>='2012-05-01' and date<='2012-05-30'
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 18 in the jsp file: /result_count.jsp
sumcount cannot be resolved to a variable
15:
16: <td width="100%" style="font-size:14pt;color:blue;padding-left:70px;" align="left"> <b>Total Salary From : </b>
17: <jsp:useBean id="sum" class="com.SumCountBean" scope="request">
18: <jsp:setProperty name="sum" property="sumCount" value="<%=request.getAttribute(sumcount)%>"/>
19: <jsp:setProperty name="sum" property="sdate" value="<%=request.getAttribute(sdate)%>"/>
20: <jsp:setProperty name="sum" property="edate" value="<%=request.getAttribute(edate)%>"/>
21: </jsp:useBean>
An error occurred at line: 19 in the jsp file: /result_count.jsp
sdate cannot be resolved to a variable
16: <td width="100%" style="font-size:14pt;color:blue;padding-left:70px;" align="left"> <b>Total Salary From : </b>
17: <jsp:useBean id="sum" class="com.SumCountBean" scope="request">
18: <jsp:setProperty name="sum" property="sumCount" value="<%=request.getAttribute(sumcount)%>"/>
19: <jsp:setProperty name="sum" property="sdate" value="<%=request.getAttribute(sdate)%>"/>
20: <jsp:setProperty name="sum" property="edate" value="<%=request.getAttribute(edate)%>"/>
21: </jsp:useBean>
22:
An error occurred at line: 20 in the jsp file: /result_count.jsp
edate cannot be resolved to a variable
17: <jsp:useBean id="sum" class="com.SumCountBean" scope="request">
18: <jsp:setProperty name="sum" property="sumCount" value="<%=request.getAttribute(sumcount)%>"/>
19: <jsp:setProperty name="sum" property="sdate" value="<%=request.getAttribute(sdate)%>"/>
20: <jsp:setProperty name="sum" property="edate" value="<%=request.getAttribute(edate)%>"/>
21: </jsp:useBean>
22:
23:
Stacktrace:
at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92)
at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
at org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:439)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:356)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:334)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:321)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:592)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at sumcount.doPost(sumcount.java:45)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
at java.lang.Thread.run(Thread.java:619)
PHPSudhir Kumar Pandey April 5, 2011 at 11:28 AM
Program
Regarding error in the given tutorialvikas May 24, 2012 at 3:50 PM
Hello Sir, I followed ur tutorial entitled "Display Sum Of table using in jsp" but it comes out with following error while showing the total salary .any help will be heartly appreciated.Entering salary is working fine.thnx Connected to the database query select sum(emp_salary) from sumcount where date>='2012-05-01' and date<='2012-05-30' org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 18 in the jsp file: /result_count.jsp sumcount cannot be resolved to a variable 15: 16: <td width="100%" style="font-size:14pt;color:blue;padding-left:70px;" align="left"> <b>Total Salary From : </b> 17: <jsp:useBean id="sum" class="com.SumCountBean" scope="request"> 18: <jsp:setProperty name="sum" property="sumCount" value="<%=request.getAttribute(sumcount)%>"/> 19: <jsp:setProperty name="sum" property="sdate" value="<%=request.getAttribute(sdate)%>"/> 20: <jsp:setProperty name="sum" property="edate" value="<%=request.getAttribute(edate)%>"/> 21: </jsp:useBean> An error occurred at line: 19 in the jsp file: /result_count.jsp sdate cannot be resolved to a variable 16: <td width="100%" style="font-size:14pt;color:blue;padding-left:70px;" align="left"> <b>Total Salary From : </b> 17: <jsp:useBean id="sum" class="com.SumCountBean" scope="request"> 18: <jsp:setProperty name="sum" property="sumCount" value="<%=request.getAttribute(sumcount)%>"/> 19: <jsp:setProperty name="sum" property="sdate" value="<%=request.getAttribute(sdate)%>"/> 20: <jsp:setProperty name="sum" property="edate" value="<%=request.getAttribute(edate)%>"/> 21: </jsp:useBean> 22: An error occurred at line: 20 in the jsp file: /result_count.jsp edate cannot be resolved to a variable 17: <jsp:useBean id="sum" class="com.SumCountBean" scope="request"> 18: <jsp:setProperty name="sum" property="sumCount" value="<%=request.getAttribute(sumcount)%>"/> 19: <jsp:setProperty name="sum" property="sdate" value="<%=request.getAttribute(sdate)%>"/> 20: <jsp:setProperty name="sum" property="edate" value="<%=request.getAttribute(edate)%>"/> 21: </jsp:useBean> 22: 23: Stacktrace: at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92) at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330) at org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:439) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:356) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:334) at org.apache.jasper.compiler.Compiler.compile(Compiler.java:321) at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:592) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) at sumcount.doPost(sumcount.java:45) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675) at java.lang.Thread.run(Thread.java:619)
databaseinayat December 17, 2012 at 2:02 AM
hello sir..i need the db for this application..plz provide db asap thanks
Post your Comment