2 Replies Latest reply on Aug 15, 2017 5:00 AM by Mirko Gogic

    Jboss Server datasource pool damp

    Mirko Gogic Newbie

      Hi,

       

      Am using Jboss 6.2 and some of the deployed applications are starting to use way too many datasource sessions.
      Problem is not consistent , so I need to wait for it to start hapening and then see why do I have such a huge pool usage.

       

      Can somone help, am looking for ways to debug this, best thing would be i think if I could dump all the data from the current sessions
      and then see maybe there is some info regarding what is creating this problem ?

       

      How can I do that ? Could you plase point me to some info regarding this topic.

       

      Thx

        • 1. Re: Jboss Server datasource pool damp
          Amit Nijhawan Newbie

          Is there any specific reason to use older version of Jboss 6.2? ,Please jump on latest release Jboss EAP 7.I need to know the pool size which you have configured in conf file,please attach the datasource configuration file with us.

          • 2. Re: Jboss Server datasource pool damp
            Mirko Gogic Newbie

            Here is the domain pool datasource config

             

             

            <subsystem xmlns="urn:jboss:domain:datasources:1.1">
              <datasources>
              <datasource jndi-name="myJndiName" pool-name="myPoolName" enabled="true" use-java-context="true" jta="true">
              <connection-url>localhost</connection-url>
              <driver>oracle</driver>
              <pool>
              <min-pool-size>10</min-pool-size>
              <max-pool-size>100</max-pool-size>
              <prefill>true</prefill>
              <use-strict-min>false</use-strict-min>
              </pool>
              <security>
              <user-name>user</user-name>
              <password>pass</password>
              </security>
              <validation>
              <check-valid-connection-sql>select * from dual</check-valid-connection-sql>
              <background-validation>true</background-validation>
              <background-validation-millis>10000</background-validation-millis>
              </validation>
              </datasource>
              <drivers><driver name="oracle" module="com.oracle.ojdbc">
              <xa-datasource-class>oracle.jdbc.OracleDriver</xa-datasource-class>
              </driver>
              </drivers>
              </datasources>
            </subsystem>