[SOA-3473] It is not possible to use XA transactions with SOA platform + Postgress 8.4 using implicit Postgress settings - JBoss Issue Tracker

XML

Word

Printable

Release Notes Text:

Hide
https://issues.jboss.org/browse/SOA-3473

In order to use XA transactions with a PostgreSQL 8.4 backing store, you will need to change the default value of max_prepare_transactions in your postgresql.conf file. As of 8.4, the default setting for this property is 0. Please choose a number of prepared transactions equal to or greater the maximum number of connections specified in your postgresql.conf - so that there is a transaction available per connection.

Show
https://issues.jboss.org/browse/SOA-3473 In order to use XA transactions with a PostgreSQL 8.4 backing store, you will need to change the default value of max_prepare_transactions in your postgresql.conf file. As of 8.4, the default setting for this property is 0. Please choose a number of prepared transactions equal to or greater the maximum number of connections specified in your postgresql.conf - so that there is a transaction available per connection.
Release Notes Docs Status:
Documented as Known Issue

PRD for SOA P 5.2 requires RHEL 5.5/6 PostgreSQL config in version 8.4 to work "(as delivered)".

In Postgress 8.4 implicit settings of max_prepared_transactions is changed to 0 that means XA transactions are turned off.

That means SOA-P is not certifiable with this configuration.