IBM Support

PI86053: ECLIPSELINK ADDS DEFAULT SCHEMA TWICE FOR SEQS ON DB2

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When the sequenceGenerator in EclipseLink persists a new entity
    launching a SQL query to DB2, a SQL -104 is thrown because the
    default schema name is doubled, e.g.
    CISYS.TEST_SEQ is expected but
    CISYS.CISYS.TEST_SEQis created.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server V9 - Java Persistence API (JPA       *
    *                  2.1)                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: EclipseLink adds double schema          *
    *                      references to sequence queries on DB2   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When the default schema is set (orm.xml or
    persistence property) on DB2, then the generated SQL used to
    get NEXT VALUE has two schemas on it.
    Exception:
    Internal Exception: com.ibm.db2.jcc.am.vo: DB2 SQL Error:
    SQLCODE=-104, SQLSTATE=42601, SQLERRMC=.;AT MICROSECONDS
    MICROSECOND SECONDS SECOND MINUTES MINUTE HOURS, DRIVER=4.8.87
    Error Code: -104
    Call: VALUES(NEXT VALUE FOR CISYS.CISYS.TEST_SEQ)
    Query: ValueReadQuery(sql="VALUES(NEXT VALUE FOR
    CISYS.CISYS.TEST_SEQ)")
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI86053

  • Reported component name

    WEBSPHERE FOR Z

  • Reported component ID

    5655I3500

  • Reported release

    900

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-08-17

  • Closed date

    2017-10-10

  • Last modified date

    2017-10-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 FOR Z

  • Fixed component ID

    5655I3500

Applicable component levels

  • R900 PSY

       UP

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

Document Information

Modified date:
03 December 2021