I think I have the same problem!! Havent found a solution either. DRE
-----Original Message----- From: Jodie A [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:51 AM To: CF-Talk Subject: Re: Problem SQL & CF 5 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
