Hi Jesper,
I did try with the <security> element but that does not helps.
The <user-name> and <password> that we provide in the <security> element is the default DB credentials to acess the database.
The point is, if I have "<allow-multiple-users/>" the same credentials cannot be used by/for different users.
Here is the new updated datasource config -
<xa-datasource jndi-name="java:/etsDataSourcexa" pool-name="OracleXA_DS" enabled="true">
<xa-datasource-property name="URL">
XXXX
</xa-datasource-property>
<driver>ojdbc6.jar</driver>
<new-connection-sql>select 1 from dual</new-connection-sql>
<xa-pool>
<min-pool-size>1</min-pool-size>
<max-pool-size>100</max-pool-size>
<allow-multiple-users/>
</xa-pool>
<security>
<user-name>jboss</user-name>
<password>jboss</password>
</security>
<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
<background-validation-millis>30000000</background-validation-millis>
<stale-connection-checker class-name="org.jboss.resource.adapter.jdbc.vendor.OracleStaleConnectionChecker"/>
<exception-sorter class-name="org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter"/>
</validation>
<statement>
<prepared-statement-cache-size>25</prepared-statement-cache-size>
</statement>
</xa-datasource>
<driver name="ojdbc6.jar" module="com.oracle">
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
</driver>