Solved

weblogic JDBC connection monitoring

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VMware Workstation 12 Player 16 72
SHA2 certs for IIS AND Java? 2 80
maybe no no httpd.conf 6 45
mysql jsp example issue 32 32
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…
It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
The viewer will learn how to implement Singleton Design Pattern in Java.

785 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