Transaction Propagation across connection pool

[puneetjains]

Hi
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

regards
Puneet

[adrian.brock]

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.