IBM Support

PM96445: OPENJPA EXTERNALVALUE MAPPING WORKS INCORRECTLY WITH CRITERIAAPI MULTISELECTS

Fixes are available

8.0.0.8: WebSphere Application Server V8.0 Fix Pack 8
8.5.5.2: WebSphere Application Server V8.5.5 Fix Pack 2
8.0.0.9: WebSphere Application Server V8.0 Fix Pack 9
8.5.5.3: WebSphere Application Server V8.5.5 Fix Pack 3
8.5.5.4: WebSphere Application Server V8.5.5 Fix Pack 4
8.0.0.10: WebSphere Application Server V8.0 Fix Pack 10
8.5.5.5: WebSphere Application Server V8.5.5 Fix Pack 5
8.5.5.6: WebSphere Application Server V8.5.5 Fix Pack 6
8.0.0.11: WebSphere Application Server V8.0 Fix Pack 11
8.5.5.7: WebSphere Application Server V8.5.5 Fix Pack 7
8.5.5.8: WebSphere Application Server V8.5.5 Fix Pack 8
8.0.0.12: WebSphere Application Server V8.0 Fix Pack 12
8.5.5.9: WebSphere Application Server V8.5.5 Fix Pack 9
8.5.5.10: WebSphere Application Server V8.5.5 Fix Pack 10
8.5.5.11: WebSphere Application Server V8.5.5 Fix Pack 11
8.0.0.13: WebSphere Application Server V8.0 Fix Pack 13
8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12
8.0.0.14: WebSphere Application Server V8.0 Fix Pack 14
8.5.5.13: WebSphere Application Server V8.5.5 Fix Pack 13
8.0.0.15: WebSphere Application Server V8.0 Fix Pack 15
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14
8.5.5.15: WebSphere Application Server V8.5.5 Fix Pack 15
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14
8.5.5.17: WebSphere Application Server V8.5.5 Fix Pack 17
8.5.5.20: WebSphere Application Server V8.5.5.20
8.5.5.18: WebSphere Application Server V8.5.5 Fix Pack 18
8.5.5.19: WebSphere Application Server V8.5.5 Fix Pack 19
8.5.5.16: WebSphere Application Server V8.5.5 Fix Pack 16
8.5.5.21: WebSphere Application Server V8.5.5.21

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

Local fix

  • No known work around at this time.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server V8.0.0, V8.5.0, and V8.5.5 who make  *
    *                  use of JPA @ExternalValues.                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: SELECT fields with @ExternalValues      *
    *                      defined returns datastore values        *
    *                      instead of unmapped fields.             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    If entity fields is annotated with the following:
    @ExternalValues( { "SMALL=SML", "MEDIUM=MID", "LARGE=LRG" })
    private String s1;
    An object query as follows will return umapped value in
    the object:
    Query q = em.createQuery("SELECT a from EntityA a");
    EntityA aPrime = (EntityA) q.getSingleResult();
    Assert.assertEquals("SMALL", aPrime.getS1());
    However, a field query like the following will return mapped
    value from the datastore:
    q = em.createQuery("SELECT t0.s1 FROM EntityA t0");
    List<Object[]> res = q.getResultList();
    Iterator<Object[]> itr = res.iterator();
    Object[] values = itr.next();
    Assert.assertEquals("SMALL", values[1]);
    The previous 'assertEquals' will fail as values[1]=="SML".
    This problem also causes a similarly structured CritieriaAPI
    query to return incorrect values.
    If the field type is boolean, even if the database has "true"
    value, both of the above scenario will return false, due to
    new Boolean("non-true") always return false.
    

Problem conclusion

  • With this fix, code has been added to OpenJPA to ensure that
    @ExternalValues are properly mapped.
    
    The fix for this APAR is currently targeted for
    inclusion in Service Levels (Fix Packs) 8.0.0.8 and
    8.5.5.2 of WebSphere Application Server versions 8.0.0 and
    8.5.5.
    
    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

    PM96445

  • 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

    2013-09-05

  • Closed date

    2013-12-10

  • Last modified date

    2013-12-10

  • 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

  • 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:
28 April 2022