Checking a connection string/database through a website.

[djheath]

Hi we currently use Host monitor to great effect. Version 6.10

We had a problem last night where our web developing company accidently changed the database connection string to a wrong value. This meant that the website couldn't connect to the live production database and our website was producing errors for two hours before it was noticed.

The webserver uses TomCat on a linux server.

Is there a way for hostmonitor to check the connection to the database through the website, either directly or by checking amendments to the connection string used by the websever?

This would be very useful to monitor connection success rates and stop problems like the above, from happening again.

Thanks.

[KS-Soft Europe]

Is there a way for hostmonitor to check the connection to the database through the website, either directly or by checking amendments to the connection string used by the websever?

I would suggest you following solution:
You may create the simple JSP web page, that only should repform the request to the database and writes output like 'Database is Ok' in case the request was successful, and write 'Database Error' in other case.
Now you should set the URL or HTTP test up, using foregoing web page URL, and use "Check content" option to resolve is the database alive or not.

Regards,
Max