Re: FAQ update about transaction interleaving

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

Browse pgsql-jdbc by date

  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