JDBC CONNECTIVITY POOLS

[notnarayanshankar venkatraman]

i need to write a java code to monitor the JDBC connectivity pools. which all parameters do i have to monitor under this and which are the apis that i need to use. how do i start with this. also the output of this has to written onto a flat file. please help

[Jeanne Boyarsky]

Notnarayanshankar,
Is there any reason you don't want to use a profiler to do this for you?

[notnarayanshankar venkatraman]

Hi, i cant use a profiler for this as i have another software (nagios) which will read the flat file and display its outputs..! How do i go bout it..! Are there any api which i can use to monitor the Jdbc pools, if so, which are they..!

[notnarayanshankar venkatraman]

Hi..! Im not very well versed with a profiler, could you please tell me how it works. I need to write the data onto a flat file for an other monitoring software to read them and process the outputs on its gui. Which api do i use for profiling.

[Jeanne Boyarsky]

Originally posted by notnarayanshankar venkatraman:
Which api do i use for profiling.

That depends. Do you have an application server or a standalone application?

[notnarayanshankar venkatraman]

yes, i am tryin to use a standalone server..! Its like this, i want to monitor jdbc connection metrics using the web tool nagios, nagios has a set of programs which read the flat files. So, that way. Which api s do i use

[Jeanne Boyarsky]

I don't know what a "standalone server" is. An application server is a tool like Tomcat/JBoss/etc. A standalone application is launched through the "java" command.

[notnarayanshankar venkatraman]

my mistake i am using tomcat for this application.... please help..

[Jeanne Boyarsky]

Then you do have a server. Tomcat supports JMX which provide hooks for monitoring. Take a look at this article for details.

[notnarayanshankar venkatraman]

Hi, im havin a small problem with my files..! Iv created certain jar files which have to be put in the plugin folder of nagios. There jar files are not getting executed. And the error im getting is unable to load main class manifest. I tried addin mvf for the creation of these jar files, and the error i get after that is some io.exception..! Please help..!

[Jeanne Boyarsky]

Please post new questions in a new thread. The post above this doesn't sound like it is about JDBC.