[AMQ-3872] Implement "exactly once" delivery with JDBC and XA in the event of a failure post prepare

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.6.0
• Fix Version/s: 5.7.0
• Component/s: Message Store
• Labels: JDBC MessageStore XA recovery

Environment

jdbc persistence adapter, XA

• Assignee: Gary Tully
• Reporter: Gary Tully
• Created: 01/Jun/12 11:23
• Updated: 01/Jun/12 14:39
• Resolved: 01/Jun/12 14:39

Description

JDBC store does not honor the prepare phase so a broker failure after prepare always results in a rollback which is in violation of the contract.
In the cases where XA is required, the store needs to do its best to respect a prepare outcome.
Having the TM use last resource commit one phase (or the one phase commit optimisation) avoids this issue but is not always possible.

Issue Links

• is related to: AMQ-3305 Implement "exactly once" delivery with kahaDB and XA in the event of a failure post prepare