Re: FAQ update about transaction interleaving

["Mikael Carneholm" <Mikael(dot)Carneholm(at)WirelessCar(dot)com>]

> 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