Oracle DB Query check

[Russell Scibetti]

I have created a "plugin" to check connecting and querying an Oracle DB. 
 However, instead of needing the Oracle client installed on your 
monitoring machine, I use java (JDK1.3.1 and up) and a Jar/Zip file of 
the Oracle JDBC libraries (classes12.zip for those that know it).  It is 
a small java class that connects, runs a query and exits, and you can 
wrap it with any number of different shell scripts for running different 
queries and processing the results.  

The class takes a connection string, user, password, and query to run. 
 It returns OK if the query executes and returns any resultset, which is 
printed to the OUTPUT string.  It returns a Critical if a SQLException 
occurs or the resultset of the query is empty.  The SQLException message 
is printed as the OUTPUT if one occurs.

Is anyone interested in this code?  If so, I will email it out to the 
list.  I was just trying to avoid installing the Oracle client where I 
didn't need it, and take advantage of an already existing Java installation.

Russell Scibetti

-- 
Russell Scibetti
Quadrix Solutions, Inc.
http://www.quadrix.com
(732) 235-2335, ext. 7038




-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com