| 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: | Whole Thread | Raw Message | 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 |