Home > mailing lists

Thread: Two-phase commit with JDBC

Two-phase commit with JDBC

From

Edson Richter

Date:

25 May 2016, 02:46:04

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

Re: Two-phase commit with JDBC

From

Florent Guillaume

Date:

25 May 2016, 12:58:21

Hi,

This is not PostgreSQL-specific.

You have to acquire a XADataSource then a XAConnection from it then its Connection.

Here's a unit test doing the two phases:

https://github.com/pgjdbc/pgjdbc/blob/master/pgjdbc/src/test/java/org/postgresql/test/xa/XADataSourceTest.java#L174

Florent

On Wed, May 25, 2016 at 1:45 AM, Edson Richter <edsonrichter@hotmail.com> 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

Florent Guillaume, Director of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (ECM)
http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87

Re: Two-phase commit with JDBC

From

Jeremy Whiting

Date:

25 May 2016, 13:05:57

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)

Re: Two-phase commit with JDBC

From

Florent Guillaume

Date:

25 May 2016, 15:57:54

Hi,

This is not PostgreSQL-specific.

You have to acquire a XADataSource then a XAConnection from it then its Connection.

Here's a unit test doing the two phases:

https://github.com/pgjdbc/pgjdbc/blob/master/pgjdbc/src/test/java/org/postgresql/test/xa/XADataSourceTest.java#L174

Florent

On Wed, May 25, 2016 at 1:45 AM, Edson Richter <edsonrichter@hotmail.com> 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

Florent Guillaume, Director of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (ECM)
http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87

Re: Two-phase commit with JDBC

From

Jeremy Whiting

Date:

25 May 2016, 16:05:42

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)

Re: Two-phase commit with JDBC

From

Simon Riggs

Date:

25 May 2016, 17:07:37

On 25 May 2016 at 00:45, Edson Richter <edsonrichter@hotmail.com> wrote:

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

Yes. They are just SQL statements.

Is there any simple J2SE example around?

Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Two-phase commit with JDBC

From

Simon Riggs

Date:

25 May 2016, 20:07:32

On 25 May 2016 at 00:45, Edson Richter <edsonrichter@hotmail.com> wrote:

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

Yes. They are just SQL statements.

Is there any simple J2SE example around?

Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: Two-phase commit with JDBC

From

"Tsunakawa, Takayuki"

Date:

26 May 2016, 04:41:45

From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Florent Guillaume
This is not PostgreSQL-specific.

You have to acquire a XADataSource then a XAConnection from it then its Connection.

Here's a unit test doing the two phases:

https://github.com/pgjdbc/pgjdbc/blob/master/pgjdbc/src/test/java/org/postgresql/test/xa/XADataSourceTest.java#L174

And the chapter “Distributed Transaction” in the JDBC specification will help you to understand the API usage and the above test cases.

Regards

Takayuki Tsunakawa

Re: Two-phase commit with JDBC

From

"Tsunakawa, Takayuki"

Date:

26 May 2016, 07:41:25

From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Florent Guillaume
This is not PostgreSQL-specific.

You have to acquire a XADataSource then a XAConnection from it then its Connection.

Here's a unit test doing the two phases:

https://github.com/pgjdbc/pgjdbc/blob/master/pgjdbc/src/test/java/org/postgresql/test/xa/XADataSourceTest.java#L174

And the chapter “Distributed Transaction” in the JDBC specification will help you to understand the API usage and the above test cases.

Regards

Takayuki Tsunakawa