Solved

weblogic JDBC connection monitoring

Posted on 2012-03-12
5
1,136 Views
Last Modified: 2012-03-28
Does anyone have a suggestion on how to monitor a JDBC connection (Available connections) and create an alert in nagios or just a way to graph the number of connections.

I have a JDBC connection with 50 max connections and want to monitor how many connection are in use over a period of time.
0
Comment
Question by:mw-hosting
  • 4
5 Comments
 
LVL 47

Expert Comment

by:for_yan
ID: 37712378
0
 
LVL 47

Expert Comment

by:for_yan
ID: 37712388
this is for Weblogic 10 which has better tools to monitor JDBC connections:
http://docs.oracle.com/cd/E15051_01/wls/docs103/jdbc_admin/monitor.html
0
 
LVL 47

Expert Comment

by:for_yan
ID: 37712410
I guess this is the useful table if you want to determine
the number of active connections in the pool programmatically:

http://docs.oracle.com/cd/E13222_01/wls/docs100/ConsoleHelp/pagehelp/JDBCjdbcdatasourcesjdbcdatasourcemonitorstatisticstitle.html
0
 
LVL 47

Expert Comment

by:for_yan
ID: 37712448
check also this with some commands examples:

Monitoring JDBC Datasource Runtime Attributes using Weblogic Scripting Tool:

http://weblogic-wonders.com/weblogic/2011/01/15/monitoring-jdbc-datasource-runtime-attributes-using-wlst/
0
 
LVL 12

Accepted Solution

by:
Sharon Seth earned 500 total points
ID: 37713487
You should be able to navigate to Services --> JDBC -->DataSources and monitor the connection pool for that JDBC

Also , it is useful to enable connection leak reporting . This way , connection leaks , if any , will be reported in the logs
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
Fine Tune your automatic Updates for Ubuntu / Debian
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
This video teaches viewers about errors in exception handling.

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question