Re: cfquery timeout doesn't work out on jdbc driver
Or figure out why its running slowly, and make it run faster. =) Rick On Thu, Oct 8, 2009 at 12:01 PM, Adam Haskell wrote: > > Run it in a thread with CFthread and put a timeout on the cfjoin. > > Adam > > > On Thu, Oct 8, 2009 at 8:47 AM, Vamsi Pappu wrote: > >> >> Hi All, >> >> I have a situation here where cfquery doesn't seem to be performing well on >> jdbc driver, when I read in forums it was clearly mentioned that cfquery >> timeout doesn't support some drivers, Is there any another alternate to >> this. >> >> My requirement is no matter what happens, if query is not responding in >> given amount of time then it should timeout.Can anyone suggest a good >> advice. >> >> Thanks, >> Vamsi >> >> > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery timeout doesn't work out on jdbc driver
Run it in a thread with CFthread and put a timeout on the cfjoin. Adam On Thu, Oct 8, 2009 at 8:47 AM, Vamsi Pappu wrote: > > Hi All, > > I have a situation here where cfquery doesn't seem to be performing well on > jdbc driver, when I read in forums it was clearly mentioned that cfquery > timeout doesn't support some drivers, Is there any another alternate to > this. > > My requirement is no matter what happens, if query is not responding in > given amount of time then it should timeout.Can anyone suggest a good > advice. > > Thanks, > Vamsi > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327036 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfquery timeout doesn't work out on jdbc driver
How about installing SeeFusion and enabling one of its rules to kill threads that run for a certain about of time? If there is a running query it will kill it. It may be a hammer where you wanted a scalpel, but it would work. Since requests who area waiting for external I/O can't monitor themselves, often the only way to ensure such a timeout is with a second monitor thread. ~Brad Original Message Subject: cfquery timeout doesn't work out on jdbc driver From: Vamsi Pappu Date: Thu, October 08, 2009 7:47 am To: cf-talk My requirement is no matter what happens, if query is not responding in given amount of time then it should timeout.Can anyone suggest a good advice. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327034 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4