IBM Support

PM67594: CURSORHOLDABLEJDBCREADER DOES NOT WORK WITH TYPE 2 DRIVERS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When using the CursorHoldableJDBCReader batch datastream with
    a Type 2 database driver, the following error occurs:
    javax.ejb.TransactionRolledbackLocalException:  ; nested
    exception is: com.ibm.ws.LocalTransaction.RolledbackException:
    Resources rolled back due to unresolved action of rollback.
    
    The batch job ends in restartable state.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server Batch application                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: Using a Cursor Holdable JDBC reader     *
    *                      with a type 2 driver causes the job to  *
    *                      end in restartable state.               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Database commits were not being done after database operations
    in the CursorHoldableJDBCReaderBean resulting in
    javax.ejb.TransactionRolledbackLocalException being thrown and
    the job ending in restartable state.
    

Problem conclusion

  • Database commits are now being performed after database
    operations in the CursorHoldableJDBCReaderBean.
    
    The fix for this APAR is currently targeted for inclusion in
    fix pack 8.5.0.1.  Please refer to the Recommended Updates
    page for delivery information:
    http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM67594

  • Reported component name

    WEBS APP SERV N

  • Reported component ID

    5724H8800

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-06-25

  • Closed date

    2012-10-03

  • Last modified date

    2012-10-03

  • 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

    WEBS APP SERV N

  • Fixed component ID

    5724H8800

Applicable component levels

  • R850 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
02 November 2021