Re: XA Support for Postgres

From: Håkan Jacobsson <hakan(dot)jacobsson(at)relevanttraffic(dot)com>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: XA Support for Postgres
Date: 2008-01-08 08:27:54
Message-ID: 5580CB5EB883C44587BC48FA0E54592223CC3E8A82@RTSRV02.relevanttraffic.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Heikki,

Thanx a lot for your help!

Håkan Jacobsson - System Developer
----------------------------------------------------------------

RELEVANT TRAFFIC EUROPE AB, Riddarg 17D, SE-114 57 Sthlm, Sweden

Mobile (+46) 736 56 97 58
Direct (+46) 8 56 24 98 05
Phone to office (+46) 8 678 97 50 || Fax (+46) 8 661 19 22

-----Ursprungligt meddelande-----
Från: Heikki Linnakangas [mailto:hlinnaka(at)gmail(dot)com] För Heikki Linnakangas
Skickat: den 7 januari 2008 17:40
Till: Håkan Jacobsson
Kopia: pgsql-jdbc(at)postgresql(dot)org
Ämne: Re: SV: [JDBC] XA Support for Postgres

Håkan Jacobsson wrote:
> So, if I want XA-support I need postgresql 8.1 at least on the databases I need to use?

Yep.

> I'm using a postgres-ds.xml with XA-support (JBoss config file) which I think you suggested to use (I found it on some jira-related site). Is that all I need to have XA-support/two-phase-commit-support? I mean there is nothing to modify in my code or elsewhere?

The short answer is yes, that's all you need to do.

Note that as an important optimization, the app server won't actually do
two-phase commit unless you really use two different databases in a
transaction.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Daniel Migowski 2008-01-08 10:30:03 Re: TypeInfoCache
Previous Message Kris Jurka 2008-01-08 06:49:35 Re: Missing fields in getColumns() result