IBM Support

IC77656: QUERY GENERATOR IS NOT CHECKING IF COLUMN NAME IS CASE SENSITIVE AND USING COLUMN NAME WITHOUT QUOTES RESULTING IN EXCEPTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When generated keys is specified in a prepared statement, and
    useIdentityValLocalForAutoGeneratedKeys property is set to
    'false' or not set, JCC generates a SELECT FROM INSERT
    query to retrieve generated keys.
    
    However, the query generator is not checking if the column name
    is case sensitive (it should be within quotes if it is) and
    using the column name without quotes results in an invalid
    column SQL exception.
    

Local fix

  • Set useIdentityValLocalForAutoGeneratedKeys=true
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade JDBC driver to the one included with v9.7 Fixpack 5. *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in the JDBC driver included with v9.7
    Fixpack 5.  This is a client side fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77656

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-07-21

  • Closed date

    2012-07-04

  • Last modified date

    2012-07-04

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

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

    IC79655

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 July 2012