Are JTA 2 phase commits really reliable?

[Chandru]

Hi,

Are JTA transactions across 2 completely different DB servers really reliable?  What happens if one of them lose their network connectivity after the first phase of commit (assuming both responded positively in first phase)?

--
Chandra Sekar.S

[Sriram Narayanan]

They are reliable, based on my learning from conversations with peers.

I've not considered experimenting with them though (never mind not
using them yet).

Here's all that I've read on the topic ->
http://en.wikipedia.org/wiki/Two-phase_commit_protocol

> --
> Chandra Sekar.S
>
> --
>
> You received this message because you are subscribed to the Google Groups
> "Bangalore Open Java Users Group- BOJUG" group.
> To post to this group, send email to bo...@googlegroups.com.
> To unsubscribe from this group, send email to
> bojug+un...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/bojug?hl=.
>

[Chandru]

Thanks Sriram.  Actually this Stack Overflow comment made me wonder.

So wanted to see if anyone here has had real problems with JTA on multiple data sources or if that comment was just theoretical.

--
Chandra Sekar.S

On Tue, Nov 24, 2009 at 12:30 AM, Sriram Narayanan <srir...@gmail.com> wrote: