Jboss Server datasource pool damp

[gogicmirko]

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

[amit12345]

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.

[gogicmirko]

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>