Hi,
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>
<jndi-name>Name1</jndi-name>
<track-connection-by-tx></track-connection-by-tx>
<isSameRM-override-value>false</isSameRM-override-value>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
<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 -->
<!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->
<!-- Checks the Oracle error codes and messages for fatal errors -->
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<!-- Oracles XA datasource cannot reuse a connection outside a transaction
once enlisted in a global transaction and vice-versa -->
<no-tx-separate-pools></no-tx-separate-pools>
</xa-datasource>
<depends
optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager
Thanks
Sreenivas
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4211423#4211423
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4211423
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
