5 Replies Latest reply on Jun 27, 2008 4:02 PM by Peter Johnson

    JDBC Metrics

    Indrajoy Newbie

      Hi,

      Is there any MBean or can we get these values from jmx_console

      1. JDBC Connection Pool Wait
      2. JDBC Connection Pool Wait Threads
      3.JDBC Client Wait Time
      4.JDBC Client Wait Time Threads
      5. JDBC Connection Pool Timeout
      6. JDBC Connection Pool Timeout Threads
      7. JDBC Connection Throughput

      Thanks in advance. Any help will be really a favor.

      Indrajoy

        • 1. Re: JDBC Metrics
          Peter Johnson Master

          Try jboss.jca:name=XXX,service=ManagedConnectionPool where XXX is the JDNI name of your data source.

          • 2. Re: JDBC Metrics
            Indrajoy Newbie

            Thanks peter. I already checked that before but it gives only
            1. AvailableConnectionCount
            2. ConnectionCount
            3. MaxConnectionsInUseCount
            4. InUseConnectionCount
            5. ConnectionCreatedCount
            6. ConnectionDestroyedCount

            I am trying to explain more.
            JDBC Connection Pool Wait: Average number of connections waiting in the pool.

            JDBC Connection Pool Wait Threads:Drill Down View of threads waiting for a connection from the pool.

            JDBC Client Wait Time:Average time that a client waits for a connection from the pool

            JDBC Client Wait Time Threads:Drill Down View of threads waiting for a connection from the pool.

            JDBC Connection Pool Timeout:Number of times a client waited for a connection

            JDBC Connection Pool Timeout Threads:Drill Down View of threads that timed out after waiting for a connection from the pool

            JDBC Connection Throughput:Number of connections allocated to and returned by applications

            Can you please help me in this.

            • 3. Re: JDBC Metrics
              Peter Johnson Master

              I do not know of anything that keeps those specific statistics.

              • 4. Re: JDBC Metrics
                Indrajoy Newbie

                I am wondering is there any tool which keeps track of all this?? Any clue sir

                • 5. Re: JDBC Metrics
                  Peter Johnson Master

                  If the code is not tracking this data, then no tool will have access to the data either. Every tool I know of uses the data provided by the MBeans.