IBM Support

PH30837: ECLIPSELINK CONVERTS BOOLEAN VALUES TO INTEGER VALUES IN CASE EXPRESSIONS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When executing a JPQL query that contains Boolean literal
    values, EclipseLink replaces those literal values with Integer
    values. The result of the query is then returned as an Integer
    type, which is not intuitive and can cause a
    ClassCastException.
    

Local fix

  • The application could be rewritten to expect an Integer value,
    then the ClassCastException would not occur, however this does
    not really make sense considering the JPQL being provided.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server - Java Persistence API - JPA 2.1 &   *
    *                  EclipseLink                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: EclipseLink converts Boolean values     *
    *                      to Integer values in SQL CASE           *
    *                      expressions. Results can be Integer     *
    *                      when Boolean is expect                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    EclipseLink may not throw an exception. The result of an SQL
    query may be an Integer type when a Boolean was expected,
    leading to a ClassCastException from the application.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH30837

  • Reported component name

    LIBERTY PROFILE

  • Reported component ID

    5724J0814

  • Reported release

    900

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-10-22

  • Closed date

    2020-11-17

  • Last modified date

    2020-11-17

  • 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

    WEBSPHERE APP S

  • Fixed component ID

    5724J0800

Applicable component levels

[{"Line of Business":{"code":"LOB36","label":"IBM Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"900"}]

Document Information

Modified date:
18 November 2020