2 Replies Latest reply on Apr 29, 2003 10:25 AM by östen

    Setting pool size for Oracle XA source?

    östen
    östen Apr 28, 2003 4:23 PM

      Howdy!

      Does anyone know how to set the pool size for an Oracle XA data source?

      Are there a DTD for the oracle-xa-ds.xml anywhere??

      Peace!

      /Östen

      • 2101 Views
      • Tags:
        • 1. Re: Setting pool size for Oracle XA source?
          davidjencks
          davidjencks Apr 28, 2003 11:56 PM (in response to östen)

          <!--pooling parameters-->
          <min-pool-size>5</min-pool-size>
          <max-pool-size>100</max-pool-size>
          <blocking-timeout-millis>5000</blocking-timeout-millis>
          <idle-timeout-minutes>15</idle-timeout-minutes>

            • Actions
          • 2. Re: Setting pool size for Oracle XA source?
            östen
            östen Apr 29, 2003 10:25 AM (in response to östen)

            Thanx!

            I am using this:


            <xa-datasource>
            <jndi-name>DefaultDS</jndi-name>
            <track-connection-by-tx>true</track-connection-by-tx>
            <isSameRM-override-value>false</isSameRM-override-value>

            <managedconnectionfactory-class>org.jboss.resource.adapter.jdbc.xa.oracle.XAOracleManagedConnectionFactory</managedconnectionfactory-class>
            <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
            <xa-datasource-property name="URL">jdbc:oracle:thin:@222.222.222.222:1521:XXXXX</xa-datasource-property>
            <xa-datasource-property name="User">xxx</xa-datasource-property>
            <xa-datasource-property name="Password">xxx</xa-datasource-property>

            <min-pool-size>0</min-pool-size>
            <max-pool-size>50</max-pool-size>
            <blocking-timeout-millis>20000</blocking-timeout-millis>
            <idle-timeout-minutes>15</idle-timeout-minutes>

            <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
            </xa-datasource>

            <!--

            <depends optional-attribute-name="TransactionManagerService">jboss.tm:service=TransactionManagerService

            -->



            .. and it seems to work....

            /Östen

              • Actions