jboss5.x - Using both XA and non-XA datasource for the same database -
there places in our project need use xa transactions. in of project regular non-xa datasource do. i've been wondering, need define 2 versions of datasource, xa , non-xa, same database? i'm afraid xa transactions costly, therefore i'd avoid them if possible.
that's reasonable approach if worried performance, 2pc commit protocol can 4 times slower. of course needs qualified
- this depends on number of resource managers participating in xa txn
- 2pc more expensive requires more roundtrips.
in addition transactions can go in-doubt state when failure occurs, locks records changed part of transaction until recovered. not using xa can avoided.
Comments
Post a Comment