[jboss-user] [Datasource Configuration] - HA XA Datasource

Ross Nicholson [http://community.jboss.org/people/rnicholson10] created the discussion "HA XA Datasource" To view the discussion, visit: http://community.jboss.org/message/566687#566687 -------------------------------------------------------------- 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 -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/566687#566687] Start a new discussion in Datasource Configuration at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]