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

[Ross Nicholson]

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]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20101015/ea6a7a49/attachment.html