aspose file tools*
The moose likes JDBC and the fly likes JDBC CONNECTIVITY POOLS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC CONNECTIVITY POOLS" Watch "JDBC CONNECTIVITY POOLS" New topic
Author

JDBC CONNECTIVITY POOLS

notnarayanshankar venkatraman
Greenhorn

Joined: Apr 19, 2008
Posts: 9
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 29220
    
135

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


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
notnarayanshankar venkatraman
Greenhorn

Joined: Apr 19, 2008
Posts: 9
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
Greenhorn

Joined: Apr 19, 2008
Posts: 9
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 29220
    
135

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
Greenhorn

Joined: Apr 19, 2008
Posts: 9
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 29220
    
135

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
Greenhorn

Joined: Apr 19, 2008
Posts: 9
my mistake i am using tomcat for this application.... please help..
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29220
    
135

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

Joined: Apr 19, 2008
Posts: 9
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 29220
    
135

Please post new questions in a new thread. The post above this doesn't sound like it is about JDBC.
 
jQuery in Action, 2nd edition
 
subject: JDBC CONNECTIVITY POOLS
 
Similar Threads
JDBC monitoring
Java beans + JDBC
jdbc connectivity in applet
Monitoring
Plugins to Monitor