JBoss Community

Hi

    We have just migrated to JBoss AS 7.1.1.Final. However we've been encountering an increase in open cursor.

    Do we need to update the jdbcadapter (current version used IronJacamar 1.0.9.Final)?    

    Here's sample of our dataSource Config:

  <xa-datasource jndi-name="java:DataSourceXS" pool-name="ExampleXADS">

          <driver>oracle</driver>

           <xa-datasource-property name="URL">jdbc:oracle:thin:@UMSQUAL:1521:oradb1</xa-datasource-property>

           <xa-pool>

                <min-pool-size>8</min-pool-size>

                <max-pool-size>32</max-pool-size>

                <prefill>true</prefill>

           </xa-pool>

           <security>

                <user-name>sa</user-name>

                <password>sa</password>

           </security>

        </xa-datasource>

            <validation>
              <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
              <stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleStaleConnectionChecker"/>
              <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>
</validation>
        <timeout>
          <blocking-timeout-millis>5000</blocking-timeout-millis>
        </timeout>

        <drivers>

           <driver name="oracle" module="com.oracle.ojdbc6">

               <xa-datasource-class>oracle.jdbc.OracleDriver</xa-datasource-class>

            </driver>

        </drivers>

<driver name="oracle" module="com.oracle.ojdbc">
  
</driver>