Suppose an application uses connections to two resources, resource-A and
resource-B. There are two connection pools, both with a maximum size of
2. There are 4 threads.
Imagine this scenario:
Threads 1, 2, 3 and 4 begin transactions.
Threads 1 and 2 request connections from the resource-A
This is will occur if you are using local transactions, thus not getting xa
2pc semantics. It will not occur (at least in jboss 3.0) if you are using
xa transactions and close the connection handles as soon as you are done
doing each piece of work. The connection can be used for many open
David Jencks wrote:
The connection can be used for many open transactions
sequentially.
OK, that makes sense.
When the txs commit, the tx manager is free to choose either
connection from each pool to commit either of the transactions.
This comes as a surprise to me. Does this mean that
