Tony, Great idea. I have the added luxury that the user will not interact with this program.
My goal is to bounce the line items to a sql table during non-business hours then after some digestion serve that up to the user through standard sql queries to the now static data in the tables. I plan to look at this async approach. Perhaps write a scheduler job that will output to a saved list then set a flag or signal through a socket as Kevin King proposed. Thanks for your help. Jeff On Mon, 2007-03-12 at 14:02 -0700, Tony Gravagno wrote: > Jeff Powell wrote: > > I am running a long select via UniQuery and I'm getting a timeout. > > Is there a parameter I can change to increase the timeout? This > > operation will be done during the server's low utilization period. > > I'm using uniobjects for java on a linux (rhel es4.5) server > > connecting to unidata on a rs/6000 aix 5.3. > > If it looks like you're going to be pushing timeouts significantly then it > might be best to approach this asynchronously. Send the selection to a > phantom on the server, generate a list, then use the list to process items > from the client. Don't just phantom off the selection. Have a program do > the selection, then write a unique tickler item when the selection is done. > Your UO code can read for this item for some period of time, provide > entertainment for the user between pings (hourglass, progressbar, some > other animation). You can control the timeout simply by stopping the > server pings and asking the user what they want to do. > > I've done this for long running reports called from web clients. If it > takes more than about 20 seconds, or if there is a flag manually set that > indicates a given report will undoubtedly take more than 20 seconds, I > don't make the user wait. I give them a page they can check to see if > their report is complete. For very long reports you can send an email with > a link when a report is complete, or your remote client interface can > periodically check pending reports from menus or other places, so that you > can inform the user on-screen when a previous request is ready. > > HTH > TG@ removethisNebula-RnD.com > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
