[DBCP-428] Unsuccessful Connection enlistment in XA Transaction ignored by TransactionContext

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.4, 2.0.1
• Fix Version/s: 2.1

Environment

All

• Assignee: Unassigned
• Reporter: Vladimir Konkov
• Created: 06/Oct/14 08:18
• Updated: 24/Feb/15 03:23
• Resolved: 31/Dec/14 16:04

Description

When TransactionContext call 'enlistResource()' on Transaction it is ignored returned result. This hapens at least when XAResource throws XAException in enlistResource method. By contract XAException should not be propagated by 'enlistResource()' , instead 'false' is returned.
As result:
1. ManagedConnection returned by pool is not enlisted in transaction (application think it does)
2. Transaction itself marked for rollback (because of XaException).
3. ManagedConnection returned by pool used by application without any errors until commit on transaction is called. Changes made in not enlisted connection may be commited on other use of native connection or rolled back depending on pool config.

Issue is very dangerous especialy if changed made by application will be commited later but XA transaction in witch it made has bin rolled back.

We are hit by this bug in production using MS SQL Server and PostgreSQL JDBC drivers.