?
Solved

weblogic JDBC connection monitoring

Posted on 2012-03-12
5
Medium Priority
?
1,161 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
The purpose of this article is to demonstrate how we can use conditional statements using Python.
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.
Suggested Courses
Course of the Month12 days, 13 hours left to enroll

777 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