The Read Rows from a JDBC Table data set is used to read source test case data from a database. The data is read using a JDBC driver (which must be supplied by the user). Each column in the table of data is represented as a property. The data set then loops across the rows that were returned from the SQL query.
Complete the following fields:
Enter the name of the data set.
Designates whether the data set is global or local. Global is the default. Local data sets are created with one for each simulator. Global data sets are created once and shared by all simulators.
Whether the record after the current record (sequential access) is read, or a random record is read. Sequential reading is the default.
The upper bound on the number of records to fetch for random access. This text field is disabled if the Random check box is not selected.
Select the action for the end of the data set. You can start over, reading values from the start of the data set, or you can select the step to execute.
Enter or select the full package name of the appropriate driver class. Standard driver classes are available in the pull-down menu.
The connect string is the standard JDBC URL for your database. Enter or select the URL. The pull-down menu contains JDBC URL templates for common database managers.
Enter a user ID (if the database requires it).
Enter a password (if the database requires it).
The SQL query that is used to create the data set.
Click the Test and Keep button to test and load the data. You get a dialog window that confirms that the data set can be read, and shows the first set of data.
|
Copyright © 2014 CA Technologies.
All rights reserved.
|
|