I have indeed seen this behaviour - IE has some internal timeout which it
reaches on longer operations and then 'cleverly' tries to get it again...

However, there are no simple ways of solving it, i've personally done it in
a completely async way (which might be a bit of an overkill), where browser
polls the page for the export, which performs the export in a threaded
manner, and only attempts to return the big file once it's ready.

so, simplified:

1.
start exporting the file in a thread, get it's id and return that to the
browser with aim to refresh:
i.e
<meta http-equiv="Refresh" content
="15,url=my_export_generator.jsp?taskId=123">

2.
then in your jsp, just check if your thread's done (maybe saved its details
in some cache), if it is, simply return the content... if not.. go back to
step.1

- this way you give ie no chance of making you start the export twice,
(unless it takes a very long time to do step 1)

... hope that helps...





                                                                                       
                                                          
                      [EMAIL PROTECTED]                                                
                                                          
                      .com                     To:       [EMAIL PROTECTED]             
                                                
                                               cc:                                     
                                                          
                      21/07/03 15:33           Subject:  Re: IE loads Excel-Sheet 
twice                                                          
                      Please respond to                                                
                                                          
                      poi-user                                                         
                                                          
                                                                                       
                                                          
                                                                                       
                                                          




For some reason IE sends a request twice. It was something I ran into as
well, however, I never ran into an issue where session variables were
unaccessible. So I have no idea what that could be.

Christoph Jaeger <[EMAIL PROTECTED]> wrote:Hi,

I apologize if this is a bit off topic, but I thought someone on this
list may have experienced the same problems and found a solution
already.

I use POI to generate reports from a database. POI is used in a servlet,
which serves the Excel sheet to a web-browser.

Everything is fine for small sheets (several hundred to a few thousand
rows). The result is just as expected. But when I try to do a bigger
query (say, 7000 rows) IE behaves strangely: first a request is sent to
the server to generate the Excel file. This file is downloaded (as it
seems), but when the next page comes up in IE, showing Excel, the Excel
program sends a second request to load the sheet. This time, the session
information (included in a cookie) is "forgotten", and so the query does
not work (does only work for logged in users, but without session
information I can not determine the user).

The same thing works without any problems on my Linux box using Galeon
as a web browser (and Gnumeric or Open Office to view the Excel sheet).

Has anyone on this list already experienced a similar problem?

Thanks a lot,

Best Regards,

Christoph J�ger


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!




This communication is for informational purposes only.  It is not intended as
an offer or solicitation for the purchase or sale of any financial instrument
or as an official confirmation of any transaction. All market prices, data
and other information are not warranted as to completeness or accuracy and
are subject to change without notice. Any comments or statements made herein
do not necessarily reflect those of J.P. Morgan Chase & Co., its
subsidiaries and affiliates.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to