Tuesday, January 10, 2006

FAQs: JTA

FAQs: JTA: "Can I use more than one non-XA connection pool in distributed transactions?

No. Even if you set EnableTwoPhaseCommit=true for both TxDataSources of the connection pools, attempting to use two non-XA connection pools in the same distributed transaction will result in:

'java.sql.SQLException: Connection has already been created in this tx context for pool named {first pool's name}. Illegal attempt to create connection from another pool: {second pool's name}'

when you attempt to get the connection from the second non-XA connection pool."

0 Comments:

Post a Comment

<< Home