1 Reply Latest reply on Jul 19, 2014 1:35 PM by wdfink

    Inuseconnectioncount keep increasing

    sanjay_chaturvedi

      Have written custom resource adapter to connect to EIS i.e. Oracle coherence data source.

      Using jboss connection pool. I observed that inuseconnectioncount keep increasing.

      xa-ds.xml:

       

       

      <max-pool-size>25</max-pool-size>

        <min-pool-size>150</min-pool-size>

       

      the time server started: jmx-console showed:

      AvailableConnectionCount:150

      ConnectionCreatedCount:150

      Inuse connectioncount  0

       

      after opening same application from multiple windows around 12 reports ran in parellel. then

      AvailableConnectionCount:140

      ConnectionCreatedCount:189

      Inuse connectioncount  10


      problem is if this inusecount keep increasing, it will fill out the pool.

      I have using just con.close to close the connection with assumption that it will get back to pool.


      Please help: Its urgent.