IBM Support

LI71272: UNIVERSAL TYPE 4 XA TRANSACTION FAILS WITH XAER_PROTOOR XAER_OUTSIDE IF STATEMENT CACHED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • With com.ibm.db2.jcc.DB2XADataSource, an XA exception will occur
    (XAER_PROTO or XAER_OUTSIDE) on the second execution of a
    prepared statement within a connection, if prepared statement
    caching is used.
    
    This problem may be seen in Websphere but it is possible to
    recreate outside Websphere. The problem is that the driver is
    not resetting the XA states correctly if an error is detected
    inside the driver (for example, this problem was first
    discovered in a testcase in which the statement failed due to a
    BigDecimal overflow exception).
    

Local fix

  • Turn off prepared statement caching, or use the Type 2 driver:
    ds.setDriverType(2)
    

Problem summary

  • ERROR DESCRIPTION:
    With com.ibm.db2.jcc.DB2XADataSource, an XA exception will occur
    (XAER_PROTO or XAER_OUTSIDE) on the second execution of a
    prepared statement within a connection, if prepared statement
    caching is used.
    

Problem conclusion

  • This problem may be seen in Websphere but it is possible to
    recreate outside Websphere. The problem is that the driver is
    not resetting the XA states correctly if an error is detected
    inside the driver (for example, this problem was first
    discovered in a testcase in which the statement failed due to a
    BigDecimal overflow.
    
    Fixed in DB2 version 8 Fixpak 13 and version 9.1 Fixpak 1.
    

Temporary fix

  • Turn off prepared statement caching
    

Comments

APAR Information

  • APAR number

    LI71272

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    820

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2006-05-05

  • Closed date

    2009-02-23

  • Last modified date

    2009-02-23

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R820 PSY

       UP

  • R910 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"820","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 October 2021