IBM Support

IT32627: LWJDBC WITH ORACLE SYS_GUID() QUERY RETURNING DIFFERENT RESULT

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

  • In 5241, this would return what looks like a hex value similar
    to this:
    
    2753B605C9084EA98B4131751BB44052
    
    After they upgraded
    to 6.0.1, the same query returns the data in a different format
    (raw?) similar to this:
    
    [B@c210d010
    

Local fix

Problem summary

  • Users Affected:
    
    All
    
    
    
    Problem Description:
    
    The LWJDBC query
    that uses the Oracle SYS_GUID() built-in function to select a
    unique identifier:
    
    SELECT SYS_GUID() FROM DUAL
    
    In 5241, this returns a hex value similar
    to this:
    
    2753B605C9084EA98B4131751BB44052
    
    After upgrading to 6.0.1, the same query returns the data in
    a different format similar to this:
    
    [B@c210d010
    
    
    
    
    
    
    
    Platforms Affected:
    
    All
    

Problem conclusion

  • Resolution Summary:
    A code fix is provided.
    Fixed the problem by handling new meta data jdbc sql type for
    the query.
    
    
    
    Delivered in:
    
    6000005
    6000303
    6000203
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32627

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    600

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-04-22

  • Closed date

    2020-07-15

  • Last modified date

    2020-12-02

  • 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

    STR B2B INTEGRA

  • Fixed component ID

    5725D0600

Applicable component levels

[{"Line of Business":{"code":"LOB02","label":"AI Applications"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"600"}]

Document Information

Modified date:
03 December 2020