Hide Forgot
project_key: SOA 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 | http://www.postgresql.org/docs/8.4/static/runtime-config-resource.html#GUC-MAX-PREPARED-TRANSACTIONS] that means XA transactions are *turned off*. That means SOA-P is not certifiable with this configuration.
Curious, isn't this a consistent XA issue with every one of our products in this configuration?
David, I think we need something in the release notes like : "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: Added: Documented as Known Issue Writer: Added: dlesage Release Notes Text: Added: 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 Text: Removed: 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. Added: 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.
Thanks for that detailed note, Tom. I have put it in the Release Notes largely verbatim.
David - this is not in the release notes here: http://documentation-stage.bne.redhat.com/docs/en-US/JBoss_Enterprise_SOA_Platform/5/html-single/5.2.0_Release_Notes/index.html Can you check ASAP?? Thx!