Differnece between the transactions

Hi,

Can anybody expalin me the difference between the LOCAL_TRANSACTION and XA_TRANSACTION. Also can a single adapter connection can get connected to multiple databases using the XA_TRANSACTION. (talking to differnet databases using different adapter services,which use the same adapter connection )

Thanks in adavance,
Anil kumar.