Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group