Turning debugging on in the admin did allow me to execute the getDebugger method. It shows me all queries for that request only. But unfortunately, I'm looking for all cached queries coldfusion is currently caching.
It appears I've stumbled upon a tough on here... I think Brandon may be right. Thanks everybody... I'll keep digging. -Jim On 1/20/06, Shepherd, Brandon <[EMAIL PROTECTED]> wrote: > You are entering into unblogged territory my friend. Only a few people > have written much about what you can do with the ServiceFactory. From > what I have googled and read, it seems it might even be possible to cure > world hunger with one of its methods there was documentation on its use. > > -Brandon > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Jim Walker > Sent: Friday, January 20, 2006 11:59 AM > To: [email protected] > Subject: Re: [CFCDev] Which cached queries are in memory > > Thanks, you've pointed me in the right direction I believe. > > I get an error when executing the code you posted. Evidently, the > issue is on the factory.getDebuggingService().getDebugger() method. > > I get "Variable SQLEXECUTIVE is undefined". > > Additionally, how can I better view the methods of these objects? > <cfdump> does not show any input parameters the methods require. > > What I need is probably in the ServiceFactory somewhere, but to find > it I need more info on each object. > > Thanks in advance. > > Jim Walker > > > > > > > > On 1/20/06, Shepherd, Brandon <[EMAIL PROTECTED]> wrote: > > You can find out which queries are cached with this... > > > > <cfobject type="JAVA" action="Create" name="factory" > > class="coldfusion.server.ServiceFactory"> > > <cfset sqlexecutive = > > factory.getDebuggingService().getDebugger().getData()> > > <cfdump var="#sqlexecutive#" label="Factory"> > > > > And some more info here... > > > > http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=12 > > > > > > Not sure about memory usage and expiration, but this should get you > > started. > > > > -Brandon > > > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Jim Walker > > Sent: Friday, January 20, 2006 9:12 AM > > To: [email protected] > > Subject: [CFCDev] Which cached queries are in memory > > > > Is there a way to determine which queries have been cached and are in > > memory? > > > > I need to know which queries are cached, the memory they are using, > > and how long until they expire. > > > > Are there any coldfusion admin objects that have methods for viewing > > this? > > > > -- > > Jim Walker > > > > > > ---------------------------------------------------------- > > You are subscribed to cfcdev. To unsubscribe, send an email to > > [email protected] with the words 'unsubscribe cfcdev' as the subject > of > > the email. > > > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > > (www.cfxhosting.com). > > > > An archive of the CFCDev list is available at > > www.mail-archive.com/[email protected] > > > > > > > > > > ---------------------------------------------------------- > > You are subscribed to cfcdev. To unsubscribe, send an email to > [email protected] with the words 'unsubscribe cfcdev' as the subject of > the email. > > > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > (www.cfxhosting.com). > > > > An archive of the CFCDev list is available at > www.mail-archive.com/[email protected] > > > > > > > > > -- > Jim Walker > [EMAIL PROTECTED] > I have 100 gmail invites. Want one? > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email to > [email protected] with the words 'unsubscribe cfcdev' as the subject of > the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > (www.cfxhosting.com). > > An archive of the CFCDev list is available at > www.mail-archive.com/[email protected] > > > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email to > [email protected] with the words 'unsubscribe cfcdev' as the subject of the > email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > (www.cfxhosting.com). > > An archive of the CFCDev list is available at > www.mail-archive.com/[email protected] > > > -- Jim Walker [EMAIL PROTECTED] I have 100 gmail invites. Want one? ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
