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

Rational Integration Tester Fix Pack 1 (8.7.1.1) for 8.7.1
Rational Performance Test Server Fix Pack 1 (8.7.1.1) for 8.7.1
Rational Test Virtualization Server Fix Pack 1 (8.7.1.1) for 8.7.1

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