PH28072: JDBC RECORDING FAILS WITH SQL COMMENTS

APAR status

• Closed as program error.

Error description

• Attempts to record SQL statements that contain comments result
  in events in Recording Studio that cannot be used.
  You see the events but not the results of the queries.
  
  STEPS TO REPRODUCE:
  
  1. Record statements containing comments.
      For example, /* comment */ SELECT * FROM MY_TABLE
  
  2. Click a recorded event in Recording Studio.
  
  EXPECTED RESULTS:
  
  The data from the statement is displayed below.
  
  ACTUAL RESULTS:
  
  The message is displayed:
  
  "There are no results to view for this event"
  

Local fix

• Remove comments from the application SQL that you are recording.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Rational Integration Tester recording SQL           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * If you record Oracle SQL statements that have comments, the  *
  * events appear in Rec Studio but you cannot see the data.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Previously, when you recorded JDBC SQL statements that contained
  embedded comments, the events appeared in the Recording Studio
  view. When you clicked the events, the SQL statement or the
  result set was not displayed.
  This problem is fixed.
  

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