Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Message-ID: <20030414213210.22725.qmail@web40708.mail.yahoo.com>
Date: Mon, 14 Apr 2003 14:32:10 -0700 (PDT)
From: Lior Shliechkorn <liorshliech@yahoo.com>
Subject: [OFF-TOPIC] RE: SOLUTION Streaming XLS File to browser
To: Poi <poi-user@jakarta.apache.org>, Tomcat <tomcat-user@jakarta.apache.org>
In-Reply-To: <3E9B089D.9090500@ptc.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1872764406-1050355930=:16301"

--0-1872764406-1050355930=:16301
Content-Type: text/plain; charset=us-ascii

Thanks to a person named Kendall Coolidge I found the solution as to why the file was not coming up correctly. The problem was that I had these headers:
response.setHeader("pragma", "no-cache");

response.setHeader("Cache-Control", "no-cache");

response.setHeader("Expires", "0");
And they needed to be commented out. Wonderful!! Thanks again to all of you.

Erik Price <eprice@ptc.com> wrote:No problem, and good luck. I hope you solve it, and post the solution 
to the list when you do.


Erik


Lior Shliechkorn wrote:
> Oh, that was an old segment where I was closing the resultset and 
> statement. Thanks a lot for looking, and trying to help. I'm stumped on 
> this one =).
> 
> Have a good one,
> Lior
> 
> */Erik Price /* wrote:
> 
> I'm sorry, but I am unable to see anything wrong. (But I am not a
> master of servlets either ;) Your code is very clean and easy to read,
> though.
> 
> This is off the subject, but I am curious why in the finally block of
> "processRequest" you print out the caught exception as a SQLException:
> 
> try {
> out.flush();
> out.close();
> } catch (Exception sqlex) {
> System.err.println("SQLException thrown in processRequest()
> finally: " + sqlex.getMessage());
> sqlex.printStackTrace();
> }
> 
> Sorry that I do not know the cause of your problem (perhaps it is a
> browser problem, not your servlet?).
> 
> 
> 
> Erik
> 
> 
> 
> 
> 
> 
> Lior Shliechkorn wrote:
> >
> > Thanks, here you go.
> >
> > Lior
> >
> > */Erik Price /* wrote:
> >
> >
> >
> > Lior Shliechkorn wrote:
> > > Here is the f! ile...
> > >
> > > Thanks
> >
> > You have to include it in your email. (Hopefully it is not too
> long or
> > wider than 80-column lines! :) The list software does not
> propagate the
> > attachment.
> >
> > (Eclipse offers autoformatting of source code which can reduce the
> > width
> > of lines to less than 80 columns.)
> >
> >
> > Erik
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> >
> >
> ------------------------------------------------------------------------
> > Do you Yahoo!?
> > Yahoo! Tax Center
> > - File
> > online, calculators, forms, and more
> 
> 
> ------------------------------------------------------------------------
> Do you Yahoo!?
> Yahoo! Tax Center 
> - File 
> online, calculators, forms, and more


---------------------------------
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
--0-1872764406-1050355930=:16301--