Uploaded image for project: 'Application Server 3  4  5 and 6'
  1. Application Server 3 4 5 and 6
  2. JBAS-6819

The value of "Connections In Use Count" that gets displayed in the embedded console as the result of the "List Formatted Sub Pool Statistics" operation does not get updated after connections are closed

XMLWordPrintable

      Steps to reproduce:

      Create a new -ds.xml file. Set values for min-pool-size and max-pool-size. Request multiple connections from the connection pool. Then, close a few of these connections. Perform the "List Formatted Sub Pool Statistics" operation for this datasource. The value of "Connections In Use Count" in the result of the operation is not updated to reflect the closed connections.

      For example, when min-pool-size=5, max-pool-size=20, and there are 10 connections in use, the following is the result of the "List Formatted Sub Pool Statistics" operation after closing 2 connections:

      Sub Pool Statistics:
      Sub Pool Count: 1
      ------------------------------------------------------

      Track By Transaction: true
      Available Connections Count: 12
      Max Connections In Use Count:10
      Connections Destroyed Count:0
      *Connections In Use Count:10*
      Total Block Time:0
      Average Block Time For Sub Pool:0
      Maximum Wait Time For Sub Pool:0
      Total Timed Out:0

      The value of "Connections In Use Count" should be 8 in this case.

              fjuma1@redhat.com Farah Juma
              fjuma1@redhat.com Farah Juma
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: