[DERBY-4141] XAExceptions thrown by Derby can have errorCode 0

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.1.3.1, 10.2.1.6, 10.3.3.0, 10.4.2.0, 10.5.1.1, 10.6.1.0
• Fix Version/s: 10.3.3.1, 10.4.2.1, 10.5.1.1, 10.6.1.0
• Component/s: SQL
• Issue & fix info: Patch Available
• Assignee: Katherine Marsden
• Reporter: Katherine Marsden
• Created: 02/Apr/09 23:12
• Updated: 14/Apr/09 16:13
• Resolved: 13/Apr/09 22:22

Description

When an XAException occurs during xa.start() or other XA operation, because of an SQLException, we have an errorCode of 0, regardless of the severity. I would suggest XAER_RMFAIL for SESSION_SEVERITY or greater and XAER_RMERR for lower severity exceptions. See thread http://www.nabble.com/XAException.errorCode-on-XAException-caused-by-an-SQLException-tt22832423.html for more detail and a reproduction.