Hi,

by interest. I have a terminology (or transaction based theory) question. Our EAP documentation says

XA allows multiple resources, such as application servers, databases, caches, and message queues, to participate in the same transaction, while preserving all four ACID properties.

Is correct to say that XA transaction preserves all fourn ACID properties? When I try to recap it then

• Atomicity - all operations are executed as an atomic unit, all participants are either committed or rolled back
• Consistency - transaction brings each resource from one valid state to other valid consistent state
• Isolation - system behaves like the parallel transactions would be run in serial order
• Durabilty - once a transaction completes, all changes made during that transaction become persistent

From that point.

On consistency. We can say that after transaction ends system is consistent. But in case of fail there could be quite a long time (before recovery is processed etc.) when whole system is quite inconsistent. I mean one resource was committed and other is still waiting for being committed and querying it will return different state than that participant which was already committed.

On isolation is not maintained isn't it?

How can I understand that? Do I watch it wrong? Does XA transaction relaxes some of the ACID properties in fact? Or can you give me some reference where to search the answer?

Thanks for a clue

Ondra