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&containerType=14&container=2077]
_______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user