Tuxedo and Postgres — oracle-tech

    Forum Stats

  • 3,715,753 Users
  • 2,242,856 Discussions
  • 7,845,550 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Tuxedo and Postgres

3804333
3804333 Member Posts: 2
edited December 2018 in Tuxedo

Hi all,

I am going to use Postgres as resourse manager in Tuxedo XA-transactions.

As I recently learned Postgres doesn't support transaction migration between threads of control,

so I cannot in one transaction update some data in one service,

then call other service and see updated data in it,

because each service has its own database connection and

transaction cannot be associated with other connection.

I prepared XA resource manager switch for Postgres.

In xa_switch_t structure I set flag to TMNOMIGRATE.

In the implementation of xa_prepare() I execute "PREPARE TRANSACTION 'xid'".

This Postgres command should be executed inside transaction block, i.e. on connection

where I update my data. When I run my test program I see that xa_prepare()

was called not by my service, but by transaction manager server,

which has other database connection. Can I change this behaviour using Tuxedo settings

or I need to execute "PREPARE TRANSACTION 'xid'" directly inside my service?

Best regards,

Valery

Answers

Sign In or Register to comment.