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