Thread: PostgreSQL XA ?
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
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
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.