IBM Support

PI33718: JDBC PROXY CANNOT RECORD SQL WITH COLUMN NAMES WITH CHARACTERS ABOVE 0X7F

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When attempting to run a select statement with a column name of
    RTKᅦ S and error occurs in the third party JSQLParser library.
    
    This issue was found using DB2 for both live and simulation
    databases but is probably reproducible with any database.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of Rational Integration Tester working with JDBC   *
    * virtualization and SQL statements that contain unicode       *
    * characters in table and column names.                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * JDBC Proxy cannot record SQL with column names with          *
    * characters above 0x7F                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Rational Integration Tester v8.7.1.1 which        *
    * includes a fix for this issue                                *
    ****************************************************************
    

Problem conclusion

  • A fix for this issue was provided in version 8.7.1.1 of Rational
    Integration Tester.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI33718

  • Reported component name

    RATL INTEGRA TE

  • Reported component ID

    5725G79IT

  • Reported release

    860

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-01-29

  • Closed date

    2015-12-29

  • Last modified date

    2015-12-29

  • 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

    RATL INTEGRA TE

  • Fixed component ID

    5725G79IT

Applicable component levels

  • R800 PSN

       UP

  • R801 PSN

       UP

  • R850 PSN

       UP

  • R851 PSN

       UP

  • R860 PSN

       UP

  • R870 PSN

       UP

  • R871 PSY

       UP



Document information

More support for: Rational Test Workbench

Software version: 8.6

Reference #: PI33718

Modified date: 29 December 2015