2 Replies Latest reply on Nov 6, 2010 6:36 AM by Wolf-Dieter Fink

    HA XA Datasource

    Ross Nicholson Apprentice

      Hi,

       

      We currnently use HA local tx connections in JBoss 5.1, it is very simple to set up simply separating JNDI strings with "|", characters as follows:

       

           <local-tx-datasource>
                      <jndi-name>PhaseInformixLocalTX</jndi-name>
                      <connection-url>jdbc:informix-sqli://rampcm1:port/database:INFORMIXSERVER=oltp_cm1;IFX_LOCK_MODE_WAIT=20|jdbc:informix-sqli:
      //rampcm2:port/database:INFORMIXSERVER=oltp_cm2;IFX_LOCK_MODE_WAIT=20</connection-url>
              <url-delimeter>|</url-delimeter>
                      <driver-class>com.informix.jdbc.IfxDriver</driver-class>
                      <user-name>user</user-name>
                      <password>password</password>
              </local-tx-datasource>

       

      What I am having difficulty with is setting up a HA XA datasource, the following is my attempt which does not work:

       

      <xa-datasource>
                  <jndi-name>PhaseInformixXADS</jndi-name>
                  <xa-datasource-class>com.informix.jdbcx.IfxXADataSource</xa-datasource-class>
              <url-delimeter>|</url-delimeter>
                  <xa-datasource-property name="Description">DB Pool for phase to talk to Informix</xa-datasource-property>
                  <xa-datasource-property name="IfxIFXHOST">rampcm1|rampcm2</xa-datasource-property>
                  <xa-datasource-property name="PortNumber">PORT</xa-datasource-property>
                  <xa-datasource-property name="DatabaseName">target db</xa-datasource-property>
                  <xa-datasource-property name="ServerName">oltp_cm1|oltp_cm2</xa-datasource-property>
                  <xa-datasource-property name="User">user</xa-datasource-property>
                  <xa-datasource-property name="Password">password</xa-datasource-property>
                  <xa-datasource-property name="IfxIFX_LOCK_MODE_WAIT">20</xa-datasource-property>
                  <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                  <user-name>user</user-name>
                  <password>password</password>
                  <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.InformixExceptionSorter</exception-sorter-class-name>
                  <metadata>
                     <type-mapping>InformixDB</type-mapping>
                  </metadata>
              </xa-datasource>

       

      I simply tried to separate the host and servername using "|" characters (which I know cannot work!).

       

      Does anyone know how this should be done?

       

      Thanks,

       

      Ross