Postgres Pro
Downloads
Home   >   mailing lists

Re: Two-phase commit with JDBC - Mailing list pgsql-jdbc

From Jeremy Whiting
Subject Re: Two-phase commit with JDBC
Date
Msg-id 166789ed-b4c0-a26a-9ce7-be38ccafc350@redhat.com
Whole thread Raw
In response to Two-phase commit with JDBC  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-jdbc
Tree view
Hi Edson,
 Two phase commit is a protocol developed by the The Open Group. The group created a standard known as Open XA [1].
 PostgreSQL using JDBC provides an implementation of the XA spec. Supporting two phase commit.

 The sample application you ask for is beyond J2SE and in JEE [2] instead.
 Unless of course you accept using JTA api. This book is suggested reading and has examples. Look for examples with UserTransaction [3].

ISBN 0-13-035290-X

Regards,
Jeremy

[1] https://en.wikipedia.org/wiki/X/Open_XA
[2] https://docs.oracle.com/javaee/7/tutorial/
[3] https://docs.oracle.com/javaee/7/api/javax/transaction/UserTransaction.html

On 25/05/16 00:45, Edson Richter wrote:

Hi,

Can I use two phase commit in PostgreSQL using JDBC without JTA or XA specialized libraries (I mean, JDBC only)?

Is there any simple J2SE example around?


Thanks,

-- 
Atenciosamente,

Edson Carlos Ericksson Richter


-- 
Jeremy Whiting
Senior Software Engineer, JBoss Performance Team
Red Hat

------------------------------------------------------------
Registered Address: RED HAT UK LIMITED, Peninsular House, 30-36 Monument Street, 4th floor, London. EC3R 8NB United Kingdom
Registered in UK and Wales under Company Registration No. 3798903  Directors: Michael Cunningham (US), Michael ("Mike") O'Neill (Ireland) and Eric Shander (US)

pgsql-jdbc by date:

Previous
From: Florent Guillaume
Date:
Subject: Re: Two-phase commit with JDBC
Next
From: Simon Riggs
Date:
Subject: Re: Two-phase commit with JDBC