[jboss-user] [Beginners Corner] - ha-xa datasource - not working

spaluvuri do-not-reply at jboss.com
Tue Feb 24 03:33:02 EST 2009

hi ,

I have been using <ha-xa-datasource> for the oracle failover option in jboss.
and i have configured my oracle-ds.xml file as follows.

      <!-- list of connection URLs -->
      <xa-datasource-property name="URL">haXaUrl1|haXaUrl2</xa-datasource-property>

      <check-valid-connection-sql>VALUES CURRENT TIMESTAMP</check-valid-connection-sql>

Now, the ha is happening, i.e when i disconnect one of the datasource , jboss is able to send the request to other database.
But, i am not getting xa working done. i,e if i insert in to one database, the other database is not inserted with the record. The distributed transaction is not happening.
In a nut shell, what i need is, i want two datasources to be in high availability mode and they should be in distributed transaction mode, i,e when i do some transaction (insert,update) on one database, it should reflect the same in the other database. 
Can anyone let me know what else do i need to do other than the above configuration file?


View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4212525#4212525

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4212525

More information about the jboss-user mailing list