...
- Avoid editing recorded JDBC URLs. They must exactly match the JDBC URLs that the database is configured with.
- If you add any SQL queries, set the parameters (if any) and result set (if any).
- You can use expressions as parameter matching criteria in SQL Templates, SQL Parameters, and Result Sets. For details, see Using see Criteria Expressions to Match Valuesfor Matching Values with the Message Responder.
- If you want to adjust timing, you can modify response times as described in Modifying Response Times.
...
To configure the tool to use expressions as parameter matching criteria, you can use criteria expressions syntax, which supports comparing strings and numbers as well as matching strings using wild-cards and regular expressions. This is described in in Criteria Expressions for Matching Values with the Message Responder.
For example, the following configuration is set to match the exact salary of 80,000 to one ResultSet file and the exact salary of 100,000 to another.
You could use criteria expressions to match all salaries up to 80,000 to one ResultSet file, match all salaries between 80,000 and 100,00 to another, and match all salaries above 100,000 to a third ResultSet File. Or, you could use [*] in the SQL Template area to create a "catch all" for unmatched SQL queries.
...