PI96836: JDBC ORACLE RECORDING FAILS WITH COMPLEX CONNECTION STRINGS

Rational Performance Test Server 9.2.1
Rational Integration Tester 9.2.1
Rational Test Virtualization Server 9.2.1

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