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

    Jboss Server datasource pool damp

    gogicmirko
    gogicmirko Aug 14, 2017 8:19 AM

      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
          amit12345
          amit12345 Aug 15, 2017 2:27 AM (in response to gogicmirko)

          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.

            • Actions
          • 2. Re: Jboss Server datasource pool damp
            gogicmirko
            gogicmirko Aug 15, 2017 5:00 AM (in response to amit12345)

            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>

             

             

              • Actions