Data source in WebSphere

Difference between connection pool data source and XA data source in websphere

Xa data source :

Example :

We have two accounts with different databases In such a case we want to transfer the funds to one account to another account Then we go for Xa data source.

Connection pool data source:

Example :

I have two account with same databases In that case if we want transfer funds one account to another account then we should use connection pool data source.

XA Data Source-- its a data source where applications requires double phase commit transaction.

connection pool data source-- where applications require single phase commit transactions.