PostgreSQL XA ?

Started by FERREIRA William (COFRAMI)almost 21 years ago3 messagesgeneral
Jump to latest
#1FERREIRA William (COFRAMI)
william.ferreira@airbus.com

hi
at present my j2ee application use an Oracle database with XA transactions.
i'm migrating Oracle to PostgreSQL, and i'm looking for a XA driver for PostgreSQL.
does it exist ?

(i don't want to rewrite all my code)

regards

William Ferreira

This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
Security Notice: all e-mail, sent to or from this address, may be
accessed by someone other than the recipient, for system management and
security reasons. This access is controlled under Regulation of
Investigatory Powers Act 2000, Lawful Business Practises.

#2Kris Jurka
books@ejurka.com
In reply to: FERREIRA William (COFRAMI) (#1)
Re: PostgreSQL XA ?

On Tue, 17 May 2005, FERREIRA, William (COFRAMI) wrote:

hi at present my j2ee application use an Oracle database with XA
transactions. i'm migrating Oracle to PostgreSQL, and i'm looking for a
XA driver for PostgreSQL. does it exist ?

No, postgresql does not support distributed transactions, so it does not
have XA JDBC support.

Kris Jurka

#3Bruno Wolff III
bruno@wolff.to
In reply to: Kris Jurka (#2)
Re: PostgreSQL XA ?

On Tue, May 17, 2005 at 14:05:46 -0500,
Kris Jurka <books@ejurka.com> wrote:

On Tue, 17 May 2005, FERREIRA, William (COFRAMI) wrote:

hi at present my j2ee application use an Oracle database with XA
transactions. i'm migrating Oracle to PostgreSQL, and i'm looking for a
XA driver for PostgreSQL. does it exist ?

No, postgresql does not support distributed transactions, so it does not
have XA JDBC support.

I think someone is working on 2PC for 8.1 which would provide infrastructure
for this.