wood burning stoves*
The moose likes Performance and the fly likes monitoring sql's using JAMon Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Performance
Bookmark "monitoring sql Watch "monitoring sql New topic
Author

monitoring sql's using JAMon

ash chowdary
Greenhorn

Joined: Apr 23, 2009
Posts: 16
hi.. am trying to use JAMon to monitor my sql's.....do i need to override doFilter() method on JAMonFilter in order to monitor my sql's?...i've done like this. is it correct implementation?
steve souza
Ranch Hand

Joined: Jun 26, 2002
Posts: 861
Have you tried the jamon jdbc proxy driver? That is the easiest way to monitor your sql with jamon.

http://jamonapi.sourceforge.net/#WhatsNew22


http://www.jamonapi.com/ - a fast, free open source performance tuning api.
JavaRanch Performance FAQ
steve souza
Ranch Hand

Joined: Jun 26, 2002
Posts: 861
If you do it your way there is no need to reimplement the jamon servlet filter. Just put yours in the chain before it and monitor the db connection that way. Also, once you have a monitored connection there is no reason to keep calling monitor on it. I believe jamon checks first and won't remonitor an already monitored connection though.
ash chowdary
Greenhorn

Joined: Apr 23, 2009
Posts: 16
so you want me to use jamon jdbc proxy connection in my application? meaning


get this connection and use it in my application??
steve souza
Ranch Hand

Joined: Jun 26, 2002
Posts: 861
Yes, but it would be better not to do this in code, but make it a property that can be changed. If you don't have this then you can put it in your code that returns connections.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: monitoring sql's using JAMon