2 Replies Latest reply on Nov 6, 2010 6:36 AM by wdfink

    HA XA Datasource

    rnicholson10

      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