It must be possible because you can do it in the admin ("Disable
Connections" checkbox in the datasource advanced settings page. All this
stuff is accessible from the undocumented
"coldfusion.server.ServiceFactory" object... which contains a
DataSourceService object... which declares a disableConnection()
method... but no idea how to use it.maybe check something like the ontap framework for clues? best of luck! >-----Original Message----- >Subject: clearing connection pool/expiring connections >From: frederick valone <[EMAIL PROTECTED]> >Date: Wed, 13 Jul 2005 10:06:43 -0400 >Thread: >http://www.houseoffusion.com/cf_lists/index.cfm/method=messages >&threadid=41145&forumid=4#211739 > >I am wondering if there is a way to programaitcally expire connections >between coldfusion and oracle. > >We currently have to "bounce" our cf server everytime we take >one of our >"linked" databases down for service or make changes made to stored >procedures or cf "sees" the state of the database as it was before the >changes were made. > >We are running cfmx6.1 for j2ee on jrun. >Our operating environment is Sun Solaris. >Oracle 9i DB >Web server is Apache 2. > >Any help will be greatly appreciated ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:211749 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
