IBM Support

PI96836: JDBC ORACLE RECORDING FAILS WITH COMPLEX CONNECTION STRINGS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • You have a complex connection string such as:
    
    jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST
    = localhost)(PORT = 1521) (LOAD_BALANCE = NO) (FAILOVER=NO))
    (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
    
    When you try to record this database, you find that Topology
    Discovery works and RTCP reports traffic through the JDBC Proxy,
    but nothing is recorded.
    You see that the JDBC events are being marked with the
    connection string in lower-case such as:
    
    jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=loca
    lhost)(port=1521)(load_balance=n ... ... service_name=xe)))
    
    As this does not match the recording rule, nothing is recorded.
    
    WORKAROUNDS:
    
    - Use the connection string captured in Topology Discovery as
    the database transport setting for your recording.
    
    - Convert your database connection string to lower-case.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Rational Integration Tester and Database            *
    * Connections with complex JDBC URLs                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Database resources whose URLs contained spaces would fail to *
    * record properly.                                             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • Fixed in 9.2.1
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI96836

  • Reported component name

    RATL INTEGRA TE

  • Reported component ID

    5725G79IT

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-04-17

  • Closed date

    2018-10-03

  • Last modified date

    2018-10-03

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

       UP

  • R900 PSN

       UP

  • R901 PSN

       UP

  • R910 PSN

       UP

  • R911 PSN

       UP

  • R920 PSN

       UP

  • R921 PSY

       UP



Document information

More support for: Rational Test Workbench

Software version: 910

Reference #: PI96836

Modified date: 03 October 2018