> 1.3. How to configure application server XXX to work with the
PostgreSQL JDBC driver
> [We need some examples...]
Here's a PG XA datasource config for a JBoss app (figured out the
xa-datasource-property names by looking at the source code of the
driver):
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<xa-datasource>
<jndi-name>AppFooXADS</jndi-name>
<track-connection-by-tx/>
<isSameRM-override-value>false</isSameRM-override-value>
<xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-cla
ss>
<xa-datasource-property
name="ServerName">postgres.host</xa-datasource-property>
<xa-datasource-property
name="DatabaseName">applications</xa-datasource-property>
<xa-datasource-property
name="User">appFooUser1</xa-datasource-property>
<xa-datasource-property
name="Password">secret</xa-datasource-property>
<xa-datasource-property
name="PortNumber">5432</xa-datasource-property>
<min-pool-size>20</min-pool-size>
<max-pool-size>100</max-pool-size>
<blocking-timeout-millis>60000</blocking-timeout-millis>
</xa-datasource>
</datasources>
/Mikael