Re: XA Support for Postgres

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Håkan Jacobsson <hakan(dot)jacobsson(at)relevanttraffic(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: XA Support for Postgres
Date: 2008-01-07 16:39:33
Message-ID: 478255C5.2050203@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Daniel Migowski 2008-01-07 16:48:35 Re: TypeInfoCache
Previous Message Daniel Migowski 2008-01-07 16:35:23 Re: TypeInfoCache