RE: Determining if cf is alive and communicative

2002-12-11 Thread Timothy Heald
We had something running like this at my old job. Basically we wrote a cfm page that did a query then output just the word ok. Big IP would look for ok, if it wasn't there then it would fail over that server. Tim -Original Message- From: Kevin Bridges [mailto:[EMAIL PROTECTED]] Sent:

RE: Determining if cf is alive and communicative

2002-12-11 Thread Dan Phillips
If you prefer to get something pre-made check out http://www.deepmetrix.com/ipmonitor/ We use this to monitor basic things like ping, and if service are running. I know you can have it monitor an Oracle ODBC connection as well. Thank you, Dan Phillips Express Technologies, Inc. dba

Re: Determining if cf is alive and communicative

2002-12-11 Thread Chris Norloff
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