i'll try with standalone java class or servlet and will let you know thanks
----- Original Message ----- From: "Danny Mui" <[EMAIL PROTECTED]> To: "POI Users List" <[EMAIL PROTECTED]> Sent: Thursday, February 05, 2004 4:58 PM Subject: Re: Problen with writing big Excel file (2 172 kBytes) > can your spreadsheet be generated outside of the JSP page just fine with > the 1981 records? > > any reason not to create the spreadsheet from a servlet? it's "safer" > as you're not introducing anything else into the output stream that > might not supposed to be there (whitespace...other jsp stuff). > > Marot Laurent wrote: > > > Hi all, > > > > I'm requesting a database to create a single sheet workbook in a JSP page. I'm using POI 2.0 Final on Linux Red Hat 4CPU 1 Mbyte Ram > > > > Everything works fine if my resultset (80 fields) contains less than 1979 reccords but when i jump to 1981 records i get the error below. > > > > is there a coding/tuning way to solve this problem. > > > > Thanks alot > > > > > > org.apache.jasper.JasperException > > at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 54) > > at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) > > at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) > > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) > > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:256) > > at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) > > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:191) > > at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) > > at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2 46) > > at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) > > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417) > > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 ) > > at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) > > at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. java:171) > > at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) > > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172 ) > > at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) > > at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577) > > at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) > > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :174) > > at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) > > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193) > > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781) > > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:549) > > at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589) > > at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:666) > > at java.lang.Thread.run(Thread.java:534) > > > > > > root cause > > > > javax.servlet.ServletException > > at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp l.java:536) > > at org.apache.jsp.financeview3bExcel_jsp._jspService(financeview3bExcel_jsp.jav a:982) > > at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2 10) > > at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) > > at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) > > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) > > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:256) > > at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) > > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:191) > > at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) > > at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2 46) > > at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) > > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417) > > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180 ) > > at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) > > at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve. java:171) > > at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) > > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172 ) > > at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) > > at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577) > > at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:641) > > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :174) > > at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok eNext(StandardPipeline.java:643) > > at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) > > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) > > at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193) > > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781) > > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne ction(Http11Protocol.java:549) > > at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589) > > at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:666) > > at java.lang.Thread.run(Thread.java:534) > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
