IBM Support

JR28736: SQL "NO DATA FOUND" IS NOT RETURNED WHEN UPDATING A ROW THAT DOESNOT EXIST.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If a user tries to update a row that does not exist, there is no
    java.sql.SQLException or java.sql.SQLWarning thrown to indicate
    that the
    row did not exist. Since the SQLCODE is only trapped through
    these two
    objects in Java, the application thinks that the row existed
    and the update was successful.
    
    
    The problem is with legacy jdbc app/net driver.
    

Local fix

  • Use ExecutionContext.getUpdateCount() to get the number of rows
    updated.
    

Problem summary

  • Users affected: All users of Legacy JDBC app/net driver
    
    Problem Description:
    If a user tries to update a row that does not exist, there is no
    java.sql.SQLException or java.sql.SQLWarning thrown to indicate
    that the
    row did not exist. Since the SQLCODE is only trapped through
    these two
    objects in Java, the application thinks that the row existed
    and the update was successful.
    
    
    The problem is with legacy jdbc app/net driver.
    
    Problem Summary:
    If a user tries to update a row that does not exist, there is no
    java.sql.SQLException or java.sql.SQLWarning thrown to indicate
    that the
    row did not exist. Since the SQLCODE is only trapped through
    these two
    objects in Java, the application thinks that the row existed
    and the update was successful.
    
    
    The problem is with legacy jdbc app/net driver.
    

Problem conclusion

  • Problem First Fixed on Version 9,5 Fixpak 1 (s080328)
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR28736

  • Reported component name

    DB2 CEE WINDOWS

  • Reported component ID

    5765F3001

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-03-19

  • Closed date

    2008-05-07

  • Last modified date

    2008-05-07

  • APAR is sysrouted FROM one or more of the following:

    JR27415

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 CEE WINDOWS

  • Fixed component ID

    5765F3001

Applicable component levels

  • R820 PSY

       UP

  • R910 PSY

       UP

  • R950 PSY

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950"}]

Document Information

Modified date:
06 October 2021