Обсуждение: PostgreSQL XA ?

Поиск
Список
Период
Сортировка

PostgreSQL XA ?

От
"FERREIRA, William (COFRAMI)"
Дата:
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

Re: PostgreSQL XA ?

От
Kris Jurka
Дата:

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

Re: PostgreSQL XA ?

От
Bruno Wolff III
Дата:
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.