Re: Support for 2-Phase Commit protocol

I'm currently envolved in a Project requiring v7.4 (7.4.2?). I won't
be using distributed transaction, but transactions that span multiple
objects (all of them on the same JVM). Therefore, as I understood it
from reading the JTA spec, I should not need to use the XA "objects"
(XAConnection...) but just "plain JDBC"'s ones (Connection,
Statement...).

Then, the following question arises: does the fact that 2-Phase commit
isn't yet supported imply that I cannot use JTA? Are these to issues
unrelated?

I'll look forward for your feedback.

-----Mensaje original-----
De: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
Enviado el: lunes, 29 de marzo de 2004 18:36
Para: Alexander Staubo
CC: Freddy Villalba Arias; PostgreSQL JDBC Mailing List
Asunto: Re: [JDBC] Support for 2-Phase Commit protocol

Someone has a 2-phase commit patch and we are looking to get it into
7.5.

------------------------------------------------------------------------
---

Alexander Staubo wrote:
> This is on the PostgreSQL todo list:
>
> http://developer.postgresql.org/todo.php
>
> However, as far as I know it's not something people are working
> actively on, or at least not to the extent that we will see a release
> in the near term. I would like to be wrong, though.
>
> Seeing as this is a server issue and not specifically a JDBC issue,
> the pgsql-hackers list is probably the place to ask about the
> development status of future features.
>
> To my knowledge, Firebird (http://www.firebirdsql.org/) is the only
> open-source database that supports two-phase commits; its JDBC driver
> comes with JTA support. You may have better luck with that. Firebird
> is itself a decent database, but is going to feel like a step back
> into the '80s once you've gotten used to PostgreSQL's sleek, modern
> facilities [*].
>
> [*] Variable-length "text" data type that does not need a pre-declared

> size, virtually unlimited row sizes, online alter/drop/rename for
> tables/columns/etc., ability to index fields declared as >250 chars
> long, SQL shell with proper readline support, intelligible error
> messages, mature documentation, I could go on.
>
> Alexander.
>
> on 2004-03-29 17:19 Freddy Villalba Arias wrote:
>
> > Hi everybody,
> >
> >
> >
> > I forgot to include this other question (also urgent, sorry if I?m
> > stressing you up): does anybody know what is PostgreSQL?s current
status
> > regarding ?Two Phase Commit Protocol Support??
> >
> >
> >
> > Again, thanx.
> >
> >
> >
> > Regards,
> >
> > Freddy.
> >
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania
19073