[IronJacamar] - increase in open cursor (oracle11g)

bruno bruno [https://community.jboss.org/people/hohokampeople] created the discussion

"increase in open cursor (oracle11g)"

To view the discussion, visit: https://community.jboss.org/message/828439#828439

--------------------------------------------------------------
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>
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/828439#828439]

Start a new discussion in IronJacamar at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2098]

_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user