Thanks for your answer. I think your solution will work (I already thought about something similar, but hoped there would be some easier way out), but as you said, it's a bit of an overkill. But in the end, I will need it to work and spend the time to implement this.
One more reason for loving MS products ... Anyway, I will come back to the list if I find a different, less complex solution (maybe there is some trick to make IE behave as it should). Best Regards, Christoph > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, July 21, 2003 5:03 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: IE loads Excel-Sheet twice > > > > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
