From: | "Mikael Carneholm" <Mikael(dot)Carneholm(at)WirelessCar(dot)com> |
---|---|
To: | "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: FAQ update about transaction interleaving |
Date: | 2006-09-29 21:39:21 |
Message-ID: | 7F10D26ECFA1FB458B89C5B4B0D72C2B697329@sesrv12.wirelesscar.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Sriram Dandapani | 2006-09-29 21:44:15 | Re: [JDBC] number of transactions doubling |
Previous Message | Tom Lane | 2006-09-29 21:39:17 | Re: [JDBC] number of transactions doubling |