How do I clear the coldfusion query cache without restarting the server?

coldfusion railo cfml
Jake Feasel picture Jake Feasel · Dec 13, 2011 · Viewed 7.2k times · Source

I have several queries that I cache using the cachedwithin="#CreateTimespan(...)#" attribute of the cfquery tag. There are times when I need to clear the cache (or just re-execute the query to get a new cached copy). Historically, I've done one of two things to accomplish this -

  1. Restart the coldfusion service.
  2. Slightly alter the query in the code, say by adding or deleting whitespace.

Neither of these options are very good, especially when in production. I'm not asking for how I might expire the cache programmatically (although, that would be nice!), but more simply - how can I clear the cached queries on the server without having to resort to one of those two above methods? I'd be happy to hear about methods that work either server-wide, or application-wide, or even how to expire a specific cached query. Thanks!

Answer

Barry Jordan picture Barry Jordan · Dec 13, 2011

You can use the following:

<cfobjectcache 
    action = "clear" />

See cfdocs for a full explanation.

Related questions

How to do a cfdump inside a cfscript tag?

In order to debug I would like to dump certain variables on to my web page. How can I do that from inside a cfscript tag? I tried the following but it isn't working: <cfscript> ... <cfif cgi.…

Read More
Trying to find a syntax highlighter for ColdFusion in Notepad++

I use CFEclipse for most of my projects and heavy lifting but sometimes I find the need to do a quick fix on pages outside the project scope that is easier to accomplish in a simple text editor. I have …

Read More
Verify mail server connection programmatically in ColdFusion

I'm using custom SMTP servers and would like to verify the connection when user enters his own server credentials. Exactly the same type of check as Adobe CF and Railo allow to do when adding mail server. Sure, this does …

Read More