Re: XA Support for Postgres

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@gmail.com] För Heikki Linnakangas
Skickat: den 7 januari 2008 17:40
Till: Håkan Jacobsson
Kopia: pgsql-jdbc@postgresql.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
somejira-related site). Is that all I need to have XA-support/two-phase-commit-support? I mean there is nothing to
modifyin 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