We use a java servlet to call a .cfm page with a simple cfquery on it (see below).
This tests CF, the connection to the database, and the database itself.
Chris Norloff
<cfquery name="systemdt" datasource="#DSN#">
SELECT SYSDATE AS SELECTDT FROM DUAL
</cfquery>
<cfif systemdt.RecordCount is not 0>
<cfset txtoutput="OK_DB_CF">
<cfelse>
<cfset txtoutput="NO_DB_CF">
</cfif>
<cfoutput>
#txtoutput#
</cfoutput>
---------- Original Message ----------------------------------
from: Kevin Bridges <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Wed, 11 Dec 2002 08:58:05 -0700
>We need to write an agent in the *nix world to "ping" the cfmx services and
>determine not only if they are running but that they are able to communicate
>with an Oracle backend. Does anyone have suggestions on how to approach
>this problem?
>
>Thanks,
>
>Kevin Bridges
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
