The Data Connection data source gets data from the database by using a predefined JDBC database connection. It allows you to specify one connection and use it in several SoapUI test steps, as well as in the ServiceV data source within the project.
If you need to use this connection only once, you can use the JDBC data source.
|Note:||To use the data connection data source, you need to install a database driver. To learn how to do this, see Installing Database Drivers.|
The data source assigns values it got to the properties whose names match the names of the database columns or aliases.
A table that contains prepared properties used in the SQL Query. To learn how to work with prepared properties, see Prepared Properties.
Specifies the name of a database connection.
Opens the Database configuration dialog to modify the selected database connection.
Tests the selected database connection.
Specifies the query to the database. To use a test step parameter in the query, specify the name of the desired parameter with the leading colon character (
:parameter). You can specify the desired query manually or by using the Build SQL Query or Create Query dialog.
|Currently, you cannot use SQL queries with the double-colon (
Specifies the number of rows obtained in one database roundtrip.
|Due to specifics of the MySQL Connector/J drivers, when you work with MySQL databases, you can specify only the
Specifies if the specified SQL Query uses a stored procedure of the database.
Opens a dialog to specify an SQL Query. If the Stored Procedure option is enabled, it opens the Create Query dialog, otherwise – the Build SQL Query dialog.