Uploaded image for project: 'JBoss Enterprise SOA Platform'
  1. JBoss Enterprise SOA Platform
  2. SOA-3473

It is not possible to use XA transactions with SOA platform + Postgress 8.4 using implicit Postgress settings

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Done
    • Affects Version/s: 5.2.0.ER4
    • Fix Version/s: 5.2.0 GA
    • Component/s: Documentation
    • Labels:
      None
    • 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

      Description

      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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                dlesage David Le Sage
                Reporter:
                fnguyen Filip Nguyen
                Writer:
                David Le Sage
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: