I've had mixed results with that. From the docs : "Maximum number of seconds that each action of a query is permitted to execute before returning an error. The cumulative time may exceed this value.
For JDBC statements, ColdFusion sets this attribute. For other drivers, check driver documentation." I have yet to understand what is "each action of a query". The timeout does work, its just not always as expected though. We use Oracle exclusively, dunno about other RDBMS. DK On 9/22/05, Michael Dinowitz <[EMAIL PROTECTED]> wrote: > Lets say we have a database connection that hangs. This will cause the > template running to hang and then time out. Is there a setting in ColdFusion > or in CFQuery that will time out a query regardless of the actual query > status? i.e. the query starts running. After 1 minute, the query times out > and the time out is caught by a try/catch. the 'real' query is still running > in the DB but the template has dropped connection to it. > > I'm trying with the timeout setting in CFQUERY as well as some other things > but I can't seem to get the query to time out. Does anyone know if this is > possible? Has anyone run into this? > > Thanks > > p.s. I'll post my results if I can get it to work. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219043 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
