5 Replies Latest reply on Jul 18, 2013 4:52 AM by Wolf-Dieter Fink

    increase in open cursor (oracle11g)

    bruno bruno Newbie

      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>