[ https://issues.jboss.org/browse/TEIIDDES-1980?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-1980: ---------------------------------------- The simple answer is to create a connection profile with a driver definition with the appropriate driver class (i.e. .... XAOracleDriver ) These basic JDBC properties get passed to Teiid when creating a Data Source and end up in the standalone.xml There are different configuration properties that you can add for pooling and other features, but the connection profile only provides a generic "add/remove" key value properties option would work on that side. But our data source feature is not yet aware of an *XA* data source and how and what to look for on creation. The Teiid docs in the kit contain examples of XA -ds.xml files here are the oracle examples: *Standard* {code:xml} <!-- Add the below contents under "datasources" subsystem in the standalone-teiid.xml or deploy as -ds.xml file --> <datasources> <datasource jndi-name="java:/OracleDS" pool-name="OracleDS" enabled="true" jta="true" use-java-context="true" use-ccm="true"> <connection-url>jdbc:oracle:thin:{host}:1521:orcl</connection-url> <driver>ojdbc6.jar</driver> <pool> <prefill>false</prefill> <use-strict-min>false</use-strict-min> <flush-strategy>FailingConnectionOnly</flush-strategy> </pool> <security> <user-name>{user}</user-name> <password>{password}</password> </security> </datasource> </datasources> {code} *XA source* {code:xml} <!-- Add the below contents under "datasources" subsystem in the standalone-teiid.xml or deploy as -ds.xml file --> <datasources> <xa-datasource jndi-name="java:/OracleDS" pool-name="OracleDS" enabled="true" use-java-context="true" use-ccm="true"> <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class> <xa-datasource-property name="URL">jdbc:oracle:thin:{host}:1521:orcl</xa-datasource-property> <driver>ojdbc6.jar</driver> <!-- <new-connection-sql>select * from dual</new-connection-sql> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> --> <xa-pool> <min-pool-size>10</min-pool-size> <max-pool-size>20</max-pool-size> <is-same-rm-override>true</is-same-rm-override> <prefill>false</prefill> <use-strict-min>false</use-strict-min> <flush-strategy>FailingConnectionOnly</flush-strategy> <no-tx-separate-pools/> </xa-pool> <security> <user-name>{user}</user-name> <password>{password}</password> <!-- <security-domain>mysecurity-realm</security-domain> --> </security> <!-- <validation> <check-valid-connection-sql>select * from dual</check-valid-connection-sql> </validation> --> </xa-datasource> </datasources> {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)