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

Popular posts from this blog

android - Get AccessToken using signpost OAuth without opening a browser (Two legged Oauth) -

org.mockito.exceptions.misusing.InvalidUseOfMatchersException: mockito -

google shop client API returns 400 bad request error while adding an item -