1 Reply Latest reply on Jul 9, 2004 11:01 PM by Adrian Brock

    Transaction Propagation across connection pool

    Puneet Jain Newbie

      suppose i have 4 connection pools

      If a transaction initated from a connection taken from one of pools can be propogated to connection taken from another pool.

      is it a good design and is it okay


        • 1. Re: Transaction Propagation across connection pool
          Adrian Brock Master

          Your question makes no sense.

          ConnectionManagers control transaction insertion and they are under the
          control of the transaction manager.
          A connection pool knows nothing about transactions.

          If you mean can you use 2+ datasources to the same database in the same transaction,
          the answer is yes you can, but you need an XA DataSource for two phase commit.
          You probably also need one of the many workarounds that JBoss provides since
          very few DB vendors implement XAResource.isSameRM() correctly.