JR45623: JDBC DOESN'T REPORT SQLCODE 100 WHEN NO DATA IS UPDATED OR DELETED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • JDBC wrapper doesn't report SQLCODE +100 when no data is
    updated or deleted. This because the JDBC driver doesn't
    report any warning when NO data is updated or deleted.
    
    For example:
    
    db2 =>  SELECT * FROM N1
    
    c1          c2
    ----------- ----------
              1 3343
              2 123
    
      2 record(s) selected.
    
    db2 => UPDATE N1 SET "c1" = '123' where "c1"=3
    DB20000I  The SQL command completed successfully.
    
    The expected result is:
    SQL0100W  No row was found for FETCH, UPDATE or DELETE; or the
    result of a
    query is an empty table.  SQLSTATE=02000
    

Local fix

  • Please contact the vendor of JDBC driver and make sure there is
    SQLWarning with SQLSTATE 100 reported after executing the SQL.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users who use Federation Server JDBC wrapper                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Federation Server V9.7.0.9                        *
    ****************************************************************
    

Problem conclusion

  • With the fix, Customer can receive a warning with SQLSTATE 100.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR45623

  • Reported component name

    FEDSRVR JDBC WR

  • Reported component ID

    5724N9714

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-03

  • Closed date

    2013-12-16

  • Last modified date

    2013-12-16

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

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

    JR46425 IC95436

Fix information

  • Fixed component name

    FEDSRVR JDBC WR

  • Fixed component ID

    5724N9714

Applicable component levels

  • R970 PSN

       UP

  • R970 PSY

       UP

  • RA10 PSN

       UP

  • RA10 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

InfoSphere Federation Server
Data Sources and Wrappers - JDBC Wrapper

Software version:

9.7

Reference #:

JR45623

Modified date:

2013-12-16

Translate my page

Machine Translation

Content navigation