Have a look at this:
<cffunction name="clearConnectionPool">
<cfargument name="password" required="true">
<cfargument name="datasource" required="true">
<cfargument name="host" required="true">
<cfargument name="database" required="true">
<cfset var admin = createObject("component",
"cfide.adminapi.administrator").login(ARGUMENTS.password)>
<cfset var ds = CreateObject("component", "cfide.adminapi.datasource")>
<cfset ds.setMSSQL(name = ARGUMENTS.datasource, host = ARGUMENTS.host,
database = ARGUMENTS.database, pooling = false)>
<cfset ds.setMSSQL(name = ARGUMENTS.datasource, host = ARGUMENTS.host,
database = ARGUMENTS.database, pooling = true)>
</cffunction>
<cfset clearConnectionPool("myPassword", "datasource", "127.0.0.1",
"database")>
But, I think the last I left it, it wasn't working. It was timing out if I
remember rightly. Also, you might not need to pass in that much data, but
instead glean it from the datasource.
Just an idea.
Adrian
http://www.adrianlynch.co.uk/
-----Original Message-----
From: Adrian Lynch
Sent: 16 January 2008 16:33
To: CF-Talk
Subject: RE: cfqueryparam, cached execution plans, and changing table
structure
You should be able to do it with code. Using the Admin API you can switch a
flag (can't remember which one) off and on again for a given datasource.
This should clear the cached plan.
I had a function to do it but it's at home. If you wait about 5 hours! :OD
I also didn't get around to testing it so I was never 100% sure it worked.
Adrian
-----Original Message-----
From: Ben Mueller
Sent: 16 January 2008 16:17
To: CF-Talk
Subject: cfqueryparam, cached execution plans, and changing table
structure
We hit a problem with morning relating to cfqueryparam. A query using
cfqueryparam referenced a table whose structure had been changed (we added a
column). It appears the execution plan had been cached, and either CF7 or
SQL Server 2000 wasn't smart enough to figure out that the table had
changed, and so the query bombed. I found an old post on it here:
http://www.coldfusionjedi.com/index.cfm?mode=entry&entry=7D417738-DF64-B270-
3056B422E2F6FCAB
......and it seems the only solutions are to cycle the CF service or change
any query (in some minor way) to force CF to create a new execution plan.
Frankly, both of those solutions blow. We're constantly updating our site,
and if we have to cycle the CF service on our production servers every time
we make a database change, we'll simply be forced to abandon cfqueryparam
entirely.
Somebody please tell me there's some other solution here.
Thanks in advance,
Ben
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296667
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
