Thread: PostgreSQL XA resource manager for C/C++ apps

PostgreSQL XA resource manager for C/C++ apps

From
trn nrjn
Date:
Hi,

Could you please assist with the following when not using ODBC/JDBC?

1. Does PostgreSQL participate as an XA resource manager in an XA transaction managed by a transaction manager (eg: Oracle Tuxedo) for C/C++ applications?

2. If so, can you please advice -

                2.1. PostgreSQL xa_open string to be used for PostgreSQL XA resource manager by C/C++ applications managed by a a transaction manager (eg: Oracle Tuxedo)?

                2.2. PostgreSQL XA switch structure (xa_switch_t) to be used (similar to xaosw for Oracle database)?

                2.3. Is there any link that I can use as reference for  PostgreSQL XA resource manager?


Thanks and regards 
Shuba 

Re: PostgreSQL XA resource manager for C/C++ apps

From
Dave Cramer
Date:


On Tue, 23 Nov 2021 at 02:10, trn nrjn <shuba14@gmail.com> wrote:
Hi,

Could you please assist with the following when not using ODBC/JDBC?

1. Does PostgreSQL participate as an XA resource manager in an XA transaction managed by a transaction manager (eg: Oracle Tuxedo) for C/C++ applications?

2. If so, can you please advice -

                2.1. PostgreSQL xa_open string to be used for PostgreSQL XA resource manager by C/C++ applications managed by a a transaction manager (eg: Oracle Tuxedo)?

                2.2. PostgreSQL XA switch structure (xa_switch_t) to be used (similar to xaosw for Oracle database)?

                2.3. Is there any link that I can use as reference for  PostgreSQL XA resource manager?


Thanks and regards 
Shuba 


 Dave Cramer
www.postgres.rocks

Re: PostgreSQL XA resource manager for C/C++ apps

From
trn nrjn
Date:
Thanks Dave. This seems to use ODBC whereas I am looking for XA support in PostgreSQL C/C++ client library itself, something similar to what Oracle provides in the OCI library. Can you please suggest if there is one?

Thanks.

On Tue, 23 Nov 2021 at 7:16 PM, Dave Cramer <davecramer@postgres.rocks> wrote:


On Tue, 23 Nov 2021 at 02:10, trn nrjn <shuba14@gmail.com> wrote:
Hi,

Could you please assist with the following when not using ODBC/JDBC?

1. Does PostgreSQL participate as an XA resource manager in an XA transaction managed by a transaction manager (eg: Oracle Tuxedo) for C/C++ applications?

2. If so, can you please advice -

                2.1. PostgreSQL xa_open string to be used for PostgreSQL XA resource manager by C/C++ applications managed by a a transaction manager (eg: Oracle Tuxedo)?

                2.2. PostgreSQL XA switch structure (xa_switch_t) to be used (similar to xaosw for Oracle database)?

                2.3. Is there any link that I can use as reference for  PostgreSQL XA resource manager?


Thanks and regards 
Shuba 


 Dave Cramer
www.postgres.rocks

Re: PostgreSQL XA resource manager for C/C++ apps

From
Dave Cramer
Date:




On Thu, 25 Nov 2021 at 03:55, trn nrjn <shuba14@gmail.com> wrote:
Thanks Dave. This seems to use ODBC whereas I am looking for XA support in PostgreSQL C/C++ client library itself, something similar to what Oracle provides in the OCI library. Can you please suggest if there is one?

the project does not  provide one.  If that is the question. I am not aware of any either. Sorry .

Dave Cramer
www.postgres.rocks


Thanks.

On Tue, 23 Nov 2021 at 7:16 PM, Dave Cramer <davecramer@postgres.rocks> wrote:


On Tue, 23 Nov 2021 at 02:10, trn nrjn <shuba14@gmail.com> wrote:
Hi,

Could you please assist with the following when not using ODBC/JDBC?

1. Does PostgreSQL participate as an XA resource manager in an XA transaction managed by a transaction manager (eg: Oracle Tuxedo) for C/C++ applications?

2. If so, can you please advice -

                2.1. PostgreSQL xa_open string to be used for PostgreSQL XA resource manager by C/C++ applications managed by a a transaction manager (eg: Oracle Tuxedo)?

                2.2. PostgreSQL XA switch structure (xa_switch_t) to be used (similar to xaosw for Oracle database)?

                2.3. Is there any link that I can use as reference for  PostgreSQL XA resource manager?


Thanks and regards 
Shuba 


 Dave Cramer
www.postgres.rocks