AFAIK, the closest you can get is with the coldfusion servicefactory.
<CFOBJECT ACTION="CREATE"
TYPE="JAVA"
CLASS="coldfusion.server.ServiceFactory"
NAME="factory">
Introspecting the object you will find a few CachedQuery methods, but I
don't think any of them return SQL code. Not sure what all data you have
access to, check out the getCachedQuery method for starters.
Daniel
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Knipp, Eric
Sent: Thursday, April 28, 2005 4:00 PM
To: '[email protected]'
Subject: RE: Cached Queries
I don't think this has been exposed yet. I feel like it really oughta be
=(.
-----Original Message-----
From: Ryan Everhart [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 28, 2005 3:35 PM
To: [email protected]
Subject: Cached Queries
Hey All,
Just a quick question. Is there a way to view all of the queries (and
possibly their record sets) that are cached on a ColdFusion server at
any given time? One of my buddies is working on a administration tool
that can monitor the "health" of his CF box and he thought that this
might be a helpful piece of knowledge to have.
Thanks,
Ryan
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
-----------------------------------------
CONFIDENTIALITY NOTICE: The information contained in this e-mail and
attached document(s) may contain confidential information that is intended
only for the addressee(s). If you are not the intended recipient, you are
hereby advised that any disclosure, copying, distribution or the taking of
any action in reliance upon the information is prohibited. If you have
received this e-mail in error, please immediately notify the sender and
delete it from your system.
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
