Thank you Jochem - Any other takers able to answer my questions: > > 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?
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 ? >From: Jochem van Dieten <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re: Problem SQL & CF 5 >Date: Thu, 19 Jun 2003 15:17:45 +0200 > >Jodie A wrote: > > 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? > >Don't know, don't know, don't know. Sorry. > >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
