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? And why when I kill a Coldfusion database connection to Oracle do I need to restart the Coldfusion Application Service to make the server stable again? Is there a way around that?
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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4