[jboss-user] [IronJacamar] - increase in open cursor (oracle11g)

bruno bruno do-not-reply at jboss.com
Wed Jul 17 12:02:40 EDT 2013


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]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130717/e495b624/attachment.html 


More information about the jboss-user mailing list