Testing your solution

Use the Flow Exerciser in the IBM® App Connect Enterprise Toolkit to test your solution.

Before you begin

Complete the steps in Implementing the solution for the database stored procedures scenario.

Procedure

  1. Restart the integration node to use the new security settings.
    1. Stop the integration node by right-clicking the integration node (IBNODE) and selecting Stop.
    2. Start the integration node by right-clicking the integration node (IBNODE) and selecting Start.
  2. In the Integration Explorer view, create an integration server called default by right-clicking the integration node (IBNODE) and selecting New Integration Server. Then click OK.
  3. Deploy the DefaultPolicies Policy Project to the default integration server, by dragging it onto the default integration server in the Integration Explorer view.
  4. Open the StoredProcedures_Flow message flow.
  5. Right-click the message flow canvas, and click Start Recording.
    Your application is deployed to the integration server. If you have more than one integration server or integration node, you are prompted to select the integration server to use. Make sure that you select the integration node where you configured the configurable service.
  6. If the Ready to record message dialog displays, click Close to close the dialog.
    The message flow is now in read-only mode and ready to receive messages.
  7. Right-click the message flow canvas, and click Send Message.
    The Send Message dialog is displayed.
  8. Click Sample message to see the content of the message.
    The message includes an employee number.
    Screen capture that shows Send message dialog with Sample message selected.
  9. Click Send to send the message to the message flow.
    The Progress Information dialog displays.
  10. When the dialog indicates that the HTTP Input node received the reply message, click Close.
    Screen capture that shows Progress Information dialog.
    The message path is highlighted on the flow.
    Screen capture that shows message path highlighted on the flow.
    Note: If you do not see the expected output, review any event log error message from IBM App Connect Enterprise. You might need to restart the integration node to ensure the JDBC configurable service and database security settings are being picked up.
  11. Click the connection between the HTTP Input node and the Mapping node to see the content of the message that was sent to the flow.
    At the end of the message, you can see the employee number that was included in the message.
    Screen capture that shows the message that was sent to the flow.
  12. Click the connection between the Mapping node and the HTTP Reply node to see the content of the message after it has been processed by the Mapping node.
    At the end of the message, you can see information that was retrieved by calling the stored procedure.
    Screen capture that shows the message after it is processed by the Mapping node.
  13. Optional: To rerun the test with a different serial number, right-click the message flow canvas, click Send Message, and edit or duplicate the sample message to add a different employee number. Here are some employee numbers that you can use:
    • 000070
    • 000210
    • 000320

Results

You have successfully completed this scenario.