poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "laurent marot" <laurent.ma...@alliacom.com>
Subject Re: Problen with writing big Excel file (2 172 kBytes)
Date Fri, 06 Feb 2004 20:07:01 GMT
i'll try with standalone java class or servlet and will let you know

thanks

----- Original Message ----- 
From: "Danny Mui" <danny@muibros.com>
To: "POI Users List" <poi-user@jakarta.apache.org>
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: poi-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: poi-user-help@jakarta.apache.org
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Mime
View raw message