Hi ..

i'm working on a web-based application using JSP .. and i'm " about to " give up from that weird exception ..

org.apache.jasper.JasperException: General error
at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFil terChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain .java:193)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java: 256)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNe xt(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java: 191)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNe xt(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(St andardContext.java:2422)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNe xt(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.in voke(ErrorDispatcherValve.jav a:171)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNe xt(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:163)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNe xt(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:17 4)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNe xt(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(Co yoteAdapter.java:199)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnecti on(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(P oolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:6 83)
at java.lang.Thread.run(Thread.java:479)


root cause

javax.servlet.ServletException: General error
at org.apache.jasper.runtime.PageContextImpl.handlePa geException(PageContextImpl.j ava:536)
at org.apache.jsp.interc_jsp._jspService(interc_jsp.j ava:102)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:210)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFil terChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain .java:193)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java: 256)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNe xt(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java: 191)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNe xt(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(St andardContext.java:2422)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNe xt(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.in voke(ErrorDispatcherValve.jav a:171)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNe xt(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:163)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNe xt(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:17 4)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNe xt(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(Co yoteAdapter.java:199)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnecti on(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(P oolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:6 83)
at java.lang.Thread.run(Thread.java:479)

---------------------------------

could any1 help me on that one please? .. i can't find the excpetion cause ..
that's the script:

<% String username = (String)session.getAttribute("username");
String password = (String)session.getAttribute("password");
Statement stmt = null;
ResultSet rs= null;
String query= "";
if((username == null) || (password == null))
response.sendRedirect("sessionend.jsp");
else{

Connection con;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc : odbc : d2d");
stmt = con.createStatement();

int numjeha= Integer.parseInt(request.getParameter("count"));

String evname= (String) session.getAttribute("evname");
String evdate= (String) session.getAttribute("evdate");
String evtime= (String) session.getAttribute("evtime");
String ampm= (String) session.getAttribute("ampm");
String numppl= (String) session.getAttribute("numppl");
String servtype= (String) session.getAttribute("servtype");
String room= (String) session.getAttribute("room");

int time= Integer.parseInt(evtime);
if (ampm.equals("pm"))
time= time+ 12;
query= "insert into event(evname, evdate, evtime, numppl, servtype) values('"+evname+"', Cdate('"+evdate+"'), Clng('"+evtime+"'), Clng('"+numppl+"'), Clng('"+servtype+"'))";
stmt.execute(query);

query= "insert into internal values('"+evname+"', Cdate('"+evdate+"'), Clng('"+room+"'))";
stmt.execute(query);

String jeha="";
for (int count2= 0; count2<numjeha ; count2++){ // a loop to get a number of text fields values
jeha = request.getParameter("jeha"+count2);
query= "insert into ev_jeha values('"+evname+"', Cdate('"+evdate+"'), '"+jeha+"')";

stmt.execute(query);

}

response.sendRedirect("insertconfirm.jsp");
%>



NOTE: i'm working on Apache Tomcat v4.1 and connected to MS Access database..

I appreciate ur support ..