siteWatch

siteWatch solves the inadequacies of big brother when it comes to preforming tests of specific functionality. As an example, big bro can tell you if a server is alive, but not if the database on it is responding to querys with expected data sets.

More detail later.

Here is the test script for reference. Move to a single line for execution.

{code:none}
java -cp "

E:/CSC/Scripts/siteWatch;E:/Program Files/Apache Software Foundation/Tomcat 5.5/common/lib/whiskey.jar;
E:/Program Files/Apache Software Foundation/Tomcat 5.5/common/lib/ojdbc14.jar;
E:/Program Files/Apache Software Foundation/Tomcat 5.5/common/lib/commons-httpclient-3.0.1.jar;
E:/Program Files/Apache Software Foundation/Tomcat 5.5/common/lib/commons-logging-1.1.jar;
E:/Program Files/Apache Software Foundation/Tomcat 5.5/common/lib/commons-codec-1.3.jar"

edu.ohiou.sitewatch.SiteWatch
{code}

Note:

use javaw for windows as so not to open a cmd window


Here is a stanza for a mysql db
{code:xml}
<database>
    <label>Confluence</label>
    <driver>com.mysql.jdbc.Driver</driver>
    <url>jdbc:mysql://ginkgo.cats.ohiou.edu/confluence?autoReconnect=true</url>
    <userid>-user-</userid>
    <passwd>-pass-</passwd>
    <sql>show databases</sql>
    <successmsg>Ignore this message, all is well, these arn't the statuses you're looking for</successmsg>
    <failuremsg>Ignore this message, all is well, these arn't the statuses you're looking for</failuremsg>
    <bbsender>BSR5</bbsender>
    <bbserver>weasel.cats.ohiou.edu</bbserver>
</database>
{code}




Comments