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 <vissu.va...@gmail.com>
Date: Thu, October 08, 2009 7:47 am
To: cf-talk <cf-talk@houseoffusion.com>


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

Reply via email to