<!-- Add the below contents under "datasources" subsystem in the standalone-teiid.xml or deploy as -ds.xml file -->
<datasources>
    <xa-datasource jndi-name="java:/postgresDS" pool-name="postgresDS" enabled="true" use-java-context="true" use-ccm="true">
        <xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
        <xa-datasource-property name="PortNumber">5432</xa-datasource-property>
        <xa-datasource-property name="DatabaseName">{db-name}</xa-datasource-property>
        <xa-datasource-property name="ServerName">{host}</xa-datasource-property>        
        
        <driver>postgresql-8.3-603.jdbc3.jar</driver>
        
        <!-- 
        <new-connection-sql>select 1</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 1</check-valid-connection-sql>
        </validation>
         -->
    </xa-datasource>                
    <drivers>
        <driver name="postgresql-8.3-603.jdbc3.jar" module="org.postgresql">
            
        </driver>
    </drivers>
</datasources>
