Altug, I'm finding as well that in practice 60 minutes is the breakpoint for connection timing out. I'd love to know what would happen if you rebuilt the Tomcat code with a higher value for that static variable. I'm not sure that would be a viable solution for me long term though, since I don't want to have the production environment always having to use 'my' version of Tomcat. Let me know if it works though.
As for Michael's suggestion, there are similar workarounds as described here: Basically you need to fork off a thread to execute the query, this should set the resultset variable when it is done. Then you need to enter a loop checking to see when the thread is finished. Inside the loop of checking, you make sure that a print " " exists so that the browser will continue to stay connnected to the server. In other words, keep the browser window active with meaningless data while waiting. The only big downside about this is the fact that a significant amount of data could be delivered to the browser during the time period. If too much data (even just a single space for each iteration of the loop) gets to the client browser, you can hang up the browser. I suppose adding a counter inside the loop that only sends a space out every 10 seconds or so (or 10 minutes?) would be an easy resolution to this. I've been trying to avoid this ugly hack, but right now its looking like the only solution, aside from rebuilding tc as you described, or a completely different solution which avoids the problem such as sending the results to the user in email, or notifying the user when the results can be viewed in the application. --- Michael Mangeng <[EMAIL PROTECTED]> wrote: > Hi > > Maybe you should implement a polling mechanism where > the client can ask > wether the data is available or not... > > The session timeout has nothing to do with the http > timeout. The session > timout only defines the time after tomcat frees the > resources hold by > the session - which is used to identify a client > doint multiple requests. > > greets, > mike __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
