Recording SQL events

Recording SQL requires choosing a database. In IBM® Rational® Integration Tester, there are two methods of selecting a database for recording: Architecture School method and Recording Studio method. Both methods achieve the same result but the Architecture School method is a more direct method.

Before you begin

  1. Install the IBM Rational Integration Tester JDBC proxy. (For more information, see Setting up the JDBC proxy.)
    Note: The version number of the IBM Rational Integration Tester Platform Pack software that you are using must be the same as the version number of the Rational Integration Tester software that you are using. Therefore, if you upgraded your Rational Integration Tester installation and you want to record SQL or create database stubs, you must upgrade your Rational Integration Tester Platform Pack installation and upgrade the JDBC proxy wherever it is deployed.
  2. In Rational Test Control Panel, ensure that the proxy is registered with Rational Test Control Panel. (For more information, see Working with Rational Test Control Panel.)

Architecture School method

Procedure

There are two ways to use Architecture School’s Logical View to record a database.
  • Right-click the logical database that is to be recorded, and click Add event monitor on the menu. Alternatively, select the logical database that is to be recorded, and click Add event monitors for the selected items on the toolbar.
  • The Recording Studio opens with the resource listed in the Event Monitor window. To start recording, click Record on the Events View toolbar.
When the application under test makes SQL calls, they are visible in Recording Studio.

Recording Studio method

About this task

To use Recording Studio to record a database:

Procedure

  1. Click + on the Event Monitors toolbar to create an event monitor.

    The Select a Resource dialog box is displayed.

  2. On the Select a Resource dialog box, click the Show/Hide Recordable Resources button.
    Note: For more information, see Adding or importing operations to Event Monitor view.
  3. Select the relevant logical database.
  4. Click OK.
  5. Click Record on the Events View toolbar.

    The Create Stubbed Database Whilst Recording? dialog box is displayed.

  6. Click the No thanks, just record the SQL option button.
  7. Open the Recording Studio wizard for creating database stubs.

    The first screen of the wizard is displayed.

  8. Click the Start recording option button.
  9. Click Finish.

    When the application under test makes JDBC SQL calls, they are visible in Recording Studio’s Events View window and you can click each SQL event to view its details or to copy and paste the SQL to a test case in IBM Rational Integration Tester or to another application.

Feedback