IBM Support

PI25978: STORED PROCEDURES NOT CORRECTLY CREATED IN DATABASE STUB WHEN RIT JDBC DRIVER HOSTED WITHIN IBM WEBSPHERE APPLICATION SERVER

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Attempts to create a database stub with IBM WebSphere
    Application Server give the following error:
    
    "Simulation Database Editor: Failed to prepare stored procedure
    data.  Cursor parameter index was not found."
    
    Attempts to run the stub result in it receiving no hits.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of Rational Integration Tester                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When a user records JDBC database traffic from a WebSphere   *
    * Application Server hosted application some stored procedures *
    * are not learned and therefore are not included in            *
    * subsequently created stubs.  The stored procedure call is    *
    * shown in the Recording Studio event list so it is not        *
    * immediately obvious to the user that the stored procedure    *
    * has not been learned.                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • This was a problem specific to the use of the Rational
    Integration Tester JDBC driver in WebSphere Application Server
    behavior and was introduced in version 8.6.0. The problem has
    been in version 8.6.0.2 of Rational Integration Tester.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI25978

  • Reported component name

    RATL TEST VIRT

  • Reported component ID

    5725G9400

  • Reported release

    860

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-09-18

  • Closed date

    2015-01-02

  • Last modified date

    2015-01-02

  • 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 TEST VIRT

  • Fixed component ID

    5725G9400

Applicable component levels

  • R800 PSN

       UP

  • R801 PSN

       UP

  • R850 PSN

       UP

  • R851 PSN

       UP

  • R860 PSY

       UP



Document information

More support for: Rational Test Virtualization Server

Software version: 8.6

Reference #: PI25978

Modified date: 02 January 2015