2 Replies Latest reply on Feb 23, 2009 5:07 AM by Sreenivas Paluvuri

    Oracle XA datasoruce with jboss

    Sreenivas Paluvuri Newbie


      I am trying to configure the jboss with oraclexa datasources.
      I want two databases to be configured in the configuration file.

      I do not know how to configure two databases in xa.
      The following is my one of the datasource.

      Can anyone please let me know

      how can i give the configuration for the second database?

      Are there any other settings do i need to take care of?

      I dont know whether i am giving the correct configuration.

      please let me know.

      <xa-datasource-property name="URL">url1</xa-datasource-property>
      <xa-datasource-property name="User">test</xa-datasource-property>
      <xa-datasource-property name="Password">test123</xa-datasource-property>
      <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
      <!-- Checks the Oracle error codes and messages for fatal errors -->
      <!-- Oracles XA datasource cannot reuse a connection outside a transaction once enlisted in a global transaction and vice-versa -->


      <depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager