IBM Support

PI33728: RIT JDBC PROXY ERROR IN PARSING "SELECT CURRENT DATE AS XXX" ON DB2

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When an application issues the following SQL statement (which is
    valid for DB2), the GH JDBC driver outputs a parsing error to
    standard out (or the app server log, when running in WAS - see
    SystemOut-2,log attached):
    
    SELECT CURRENT DATE AS TODAY FROM SYSIBM.SYSDUMMY1
    
    This prevents a database stub from being created for that
    application, as stub creation does not work. RIT can see the SQL
    and the result set in the recording studio, but when it creates
    a db stub, the table in question is not included in the stub and
    the application will receive an error when run against such
    stub.
    
    As can be seen from the attached log, the error occurs when
    parsing the "AS" token from the above SQL.
    
    If the statement is changed to
    
    SELECT CURRENT DATE FROM SYSIBM.SYSDUMMY1
    
    then the error goes away.
    
    The following standard SQL:
    
    SELECT CURRENT_DATE AS TODAY FROM SYSIBM.SYSDUMMY1
    
    also works.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of Rational Integration Tester working with JDBC   *
    * Virtualisation and SQL statements that use the following DB2 *
    * special registers: CURRENT DATE, CURRENT TIME, and CURRENT   *
    * TIMESTAMP.                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * JDBC proxy error in parsing "select current date as xxx" on  *
    * DB2                                                          *
    ****************************************************************
    * 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

    PI33728

  • 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 #: PI33728

Modified date: 29 December 2015