0 Replies Latest reply on Dec 16, 2003 7:56 AM by jt54

    xa-ds.xml for Ingres

    jt54 Newbie

      Can somebody share xa-ds.xml for Ingres database. The one which I am using is not able to create Datasource with the JNDI name specified and hence deployment of MDBs failing.

      --------------

      <!-- Here's an xa example -->
      <xa-tx-datasource>
      <jndi-name>IngresDS</jndi-name>
      <xa-datasource-class>ca.edbc.jdbcx.EdbcXADataSource</xa-datasource-class>
      <xa-datasource-property name="connection-url">jdbc:edbc://indpds:21064/repurpose</xa-datasource-property>
      <user-name>ims</user-name>
      ims
      <transaction-isolation>TRANSACTION_SERIALIZABLE</transaction-isolation>



      <!--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>
      <!-- sql to call when connection is created
      <new-connection-sql>some arbitrary sql</new-connection-sql>
      -->

      <!-- sql to call on an existing pooled connection when it is obtained from pool
      <check-valid-connection-sql>select count(*) from repurpose</check-valid-connection-sql>
      -->


      <!-- pooling criteria. USE AT MOST ONE-->
      <!-- If you don't use JAAS login modules or explicit login
      getConnection(usr,pw) but rely on user/pw specified above,
      don't specify anything here -->

      <!-- If you supply the usr/pw from a JAAS login module -->
      <security-domain/>

      <!-- if your app supplies the usr/pw explicitly getConnection(usr, pw) -->
      <application-managed-security/>

      </xa-tx-datasource>






      -------------