Thank you Jochem for the response. We are using Oracle with native connection and it was my understanding this is not supported with Oracle. Is there another way?
Thank you >From: Jochem van Dieten <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re: Problem SQL & CF 5 >Date: Wed, 18 Jun 2003 17:31:54 +0200 > >Jodie A wrote: > > We have a web frontend (W2k+sp3, CF 5.0, IIS 5.0) with a bbdd backend > > (Solaris + Oracle 8.1.7.4) and our web application uses CF [Oracle80] >native > > drivers to connect to our database. > > > > When the web application (our cfm's) makes a problematic sql sentence >(For > > example : sql sentence that use all of the resources on the database >host, > > etc etc) and the dba kills the session on the oracle database that is > > executing the problematic query owned by cfserver.exe to solve the > > performance issue in the database host, the coldfusion server in the > > frontend turns unstable and needs a restart of his "Coldfusion >Application > > Service" to solve the problem and be stable/operational again. > > > > How i can solve this issue ? Any idea about it ? > > > > Can we kill cfserver sessions on the database without made Coldfusion >Server > > unstable ? > >Wouldn't it be better to prevent a long running query alltogether and >use the timeout attribute of cfquery? > >Jochem > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4