IBM Support

IC79655: 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

  • See ERROR DESCRIPTION.
    

Problem conclusion

  • First fixed with JDBC driver bundled with v9.5 Fixpack 8.
    This affects applications which use the JDBC driver.
    

Temporary fix

  • See LOCAL FIX.
    

Comments

APAR Information

  • APAR number

    IC79655

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-11-07

  • Closed date

    2012-01-09

  • Last modified date

    2012-01-09

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

    IC77656

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSN

       UP

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 January 2012