0 Replies Latest reply on Jun 28, 2012 10:12 AM by vamshi nooka

    Jboss 4.2.3 stale connection issue

    vamshi nooka Newbie

      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>