JBoss Community

Jboss 4.2.3 stall connection issue

created by vamshi nooka in Datasource Configuration - View the full discussion

Hi,

we are currently using JBoss 4.2.3 and are seeing lot of stalled transactions in the wiley.

I tried all the possible configurations in the datasource file to check for stall connections but nothing helped.

i have attached our DS file for the reference.

 

Any help would be greatly appreciated.

Tx a ton!

   

<datasources>

<xa-datasource>

    <jndi-name>xxxxxxxDS</jndi-name>

    <track-connection-by-tx/>

    <isSameRM-override-value>false</isSameRM-override-value>

    <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>

    <xa-datasource-property name="URL">jdbc:oracle:thin:xxxxxxxxxxxxxxxxx</xa-datasource-property>

    <xa-datasource-property name="User">xxxxxxxxxxxx</xa-datasource-property>

    <xa-datasource-property name="Password">xxxxxxxxxxxxxx</xa-datasource-property>

   <!--pooling parameters-->

    <min-pool-size>20</min-pool-size>

    <max-pool-size>500</max-pool-size>

    <blocking-timeout-millis>30000</blocking-timeout-millis>

    <idle-timeout-minutes>15</idle-timeout-minutes>

 

    <!-- Uses the pingDatabase method to check a conn is still valid before handing it out from the pool -->

    <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>

    <!-- Checks the Oracle error codes and messages for fatal errors -->

    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

    <!-- Oracles XA ds cannot reuse a connection outside a tx once enlisted in a global tx and vice-versa -->

    <no-tx-separate-pools/>

 

      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->

      <metadata>

         <type-mapping>Oracle9i</type-mapping>

      </metadata>

  </xa-datasource>

</datasources>







 

 

 

 

 





Reply to this message by going to Community

Start a new discussion in Datasource Configuration at Community