IBM Support

PI77555: ECLIPSELINK SCROLLABLE CURSOR RESULTS IN A CLASSCASTEXCEPTION

Fixes are available

9.0.0.5: WebSphere Application Server traditional V9.0 Fix Pack 5
9.0.0.6: WebSphere Application Server traditional V9.0 Fix Pack 6
9.0.0.7: WebSphere Application Server traditional V9.0 Fix Pack 7
17.0.0.3: WebSphere Application Server Liberty 17.0.0.3
17.0.0.4: WebSphere Application Server Liberty 17.0.0.4
18.0.0.1: WebSphere Application Server Liberty 18.0.0.1
18.0.0.2: WebSphere Application Server Liberty 18.0.0.2
9.0.0.8: WebSphere Application Server traditional V9.0 Fix Pack 8
9.0.0.9: WebSphere Application Server traditional V9.0 Fix Pack 9
18.0.0.3: WebSphere Application Server Liberty 18.0.0.3
9.0.0.10: WebSphere Application Server traditional V9.0 Fix Pack 10
18.0.0.4: WebSphere Application Server Liberty 18.0.0.4
19.0.0.1: WebSphere Application Server Liberty 19.0.0.1
19.0.0.2: WebSphere Application Server Liberty 19.0.0.2
19.0.0.3: WebSphere Application Server Liberty 19.0.0.3
9.0.0.11: WebSphere Application Server traditional V9.0 Fix Pack 11
19.0.0.4: WebSphere Application Server Liberty 19.0.0.4
19.0.0.5: WebSphere Application Server Liberty 19.0.0.5
9.0.5.0: WebSphere Application Server traditional Version 9.0.5 Refresh Pack
19.0.0.6: WebSphere Application Server Liberty 19.0.0.6
19.0.0.7: WebSphere Application Server Liberty 19.0.0.7
19.0.0.8: WebSphere Application Server Liberty 19.0.0.8
9.0.5.1: WebSphere Application Server traditional Version 9.0.5 Fix Pack 1
19.0.0.9: WebSphere Application Server Liberty 19.0.0.9
19.0.0.10: WebSphere Application Server Liberty 19.0.0.10
19.0.0.11: WebSphere Application Server Liberty 19.0.0.11
9.0.5.2: WebSphere Application Server traditional Version 9.0.5 Fix Pack 2
19.0.0.12: WebSphere Application Server Liberty 19.0.0.12
20.0.0.1: WebSphere Application Server Liberty 20.0.0.1
20.0.0.2: WebSphere Application Server Liberty 20.0.0.2
9.0.5.3: WebSphere Application Server traditional Version 9.0.5 Fix Pack 3
20.0.0.3: WebSphere Application Server Liberty 20.0.0.3
20.0.0.4: WebSphere Application Server Liberty 20.0.0.4
20.0.0.5: WebSphere Application Server Liberty 20.0.0.5
20.0.0.6: WebSphere Application Server Liberty 20.0.0.6
9.0.5.4: WebSphere Application Server traditional Version 9.0.5 Fix Pack 4
20.0.0.7: WebSphere Application Server Liberty 20.0.0.7
20.0.0.8: WebSphere Application Server Liberty 20.0.0.8
9.0.5.5: WebSphere Application Server traditional Version 9.0.5 Fix Pack 5
20.0.0.9: WebSphere Application Server Liberty 20.0.0.9
20.0.0.10: WebSphere Application Server Liberty 20.0.0.10
20.0.0.11: WebSphere Application Server Liberty 20.0.0.11
20.0.0.12: WebSphere Application Server Liberty 20.0.0.12
9.0.5.6: WebSphere Application Server traditional Version 9.0.5 Fix Pack 6

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Execution of Named native query fails with
    CWWJP9991W(ClassCastException) after using a
    ScrollableCursor
    with the same named native query.
    eclipselink   W   CWWJP9991W: java.lang.ClassCastException:
    org.eclipse.persistence.queries.SQLCall incompatible with
    java.util.Vector
    eclipselink   3   throwable
    java.lang.ClassCastException:
    org.eclipse.persistence.queries.SQLCall incompatible with
    java.util.Vector
    at
    org.eclipse.persistence.internal.queries.DatasourceCallQuery
    Mech
    anism.executeSelectCall(DatasourceCallQueryMechanism.java:29
    9)
    Once the named native query with ScrollableCursor is
    invoked,
    the getResultList of the following same named native query
    resulted into the ClassCastException.
    

Local fix

  • By using the different named native query or non-native query,
    the issue didn't happen.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server Liberty - Java Persistence APA - JPA *
    *                  2.1 & EclipseLink                           *
    ****************************************************************
    * PROBLEM DESCRIPTION: Using EclipseLink's                     *
    *                      "eclipselink.cursor.scrollable" query   *
    *                      hint on NamedQuery's results in a       *
    *                      ClassCastException                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Application is using EclipseLink's
    "eclipselink.cursor.scrollable" query hint and encountering the
    following ClassCastException.
    
    Exception:
    java.lang.ClassCastException:
    org.eclipse.persistence.queries.SQLCall incompatible with
    java.util.Vector
    	at
    java.lang.ClassCastException.<init>(ClassCastException.java:63)
    	at
    org.eclipse.persistence.internal.queries.DatasourceCallQueryMech
    anism.executeSelectCall(DatasourceCallQueryMechanism.java:299)
    	at
    org.eclipse.persistence.internal.queries.DatasourceCallQueryMech
    anism.selectAllRows(DatasourceCallQueryMechanism.java:694)
    	at
    org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelR
    eadQuery(ReadAllQuery.java:559)
    	at
    org.eclipse.persistence.queries.ObjectLevelReadQuery.executeData
    baseQuery(ObjectLevelReadQuery.java:1175)
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI77555

  • Reported component name

    LIBERTY PROFILE

  • Reported component ID

    5724J0814

  • Reported release

    855

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-03-02

  • Closed date

    2017-09-14

  • Last modified date

    2017-09-14

  • 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

    LIBERTY PROFILE

  • Fixed component ID

    5724J0814

Applicable component levels

  • R855 PSY

       UP

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

Document Information

Modified date:
18 October 2021