Solved

weblogic JDBC connection monitoring

Posted on 2012-03-12
5
1,118 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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
The purpose of this article is to demonstrate how we can use conditional statements using Python.
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now