IBM Support

PM71277: CRITERIA API GENERATED QUERIES DO NOT HANDLE PARAMETER CASTING FOR SQL FUNCTION CALLS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • OpenJPA's are not handling parameter casting for function
    calls in SQL properly and also not handling many SQL language
    constructs, especially nested function calls. The current
    implementation only processes the last parameter in the
    function call plus it uses the wrong "cast to" type. The
    solution to this problem is to process every parameter with the
    "cast to" semantics, whenever it applies, at the point each
    parameter is processed (appendTo()), rather than process
    them in batch at the later time.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: OpenJPA's Criteria API was not          *
    *                      properly type casting, inserting        *
    *                      an incorrect type cast to the last      *
    *                      parameter in the SQL                    *
    *                      construct.                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    OpenJPA's are not handling parameter casting for function
    calls in SQL properly and also not handling many SQL language
    constructs, especially nested function calls. The current
    implementation only processes the last parameter in the
    function call plus it uses the wrong "cast to" type. The
    solution to this problem is to process every parameter with the
    "cast to" semantics, whenever it applies, at the point each
    parameter is processed (appendTo()), rather than process them
    in batch at the later time.
    

Problem conclusion

  • OpenJPA has been corrected so that the Criteria API no longer
    inserts the incorrect type cast.
    
    The fix for this APAR is currently targeted for inclusion in
    fix packs 8.0.0.6 and 8.5.0.2.  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

    PM71277

  • Reported component name

    WEBSPHERE APP S

  • Reported component ID

    5724J0800

  • Reported release

    800

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-08-21

  • Closed date

    2013-01-10

  • Last modified date

    2013-01-10

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

    PM65584

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

    PM80443

Fix information

  • Fixed component name

    WEBSPHERE APP S

  • Fixed component ID

    5724J0800

Applicable component levels

  • R800 PSY

       UP

  • 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.0","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
29 October 2021