Wait For SQL Row
The task waits (at the maximum given amount of time) until the specified query returns a result containing at least one row. If the query returns no result set, the task fails immediately. If the result set contains no rows, the task keeps waiting.
Properties
Name | Type | Description | Expression support | ||
---|---|---|---|---|---|
Polling Interval (ms) |
mandatory |
The interval to wait between two checks of the condition. A value higher than zero is required. |
expression evaluating to integer |
||
Timeout (ms) |
mandatory |
The maximum amount of time the task waits for the condition to be true. After this time the task fails (that is, it does not wait anymore even if the condition is only being checked). A value higher than zero is required. |
expression evaluating to integer |
||
Query |
mandatory |
Query to execute over the database; supports variable mappings. For details about variable mapping, see Workflow Variables.
|
semi-expression |
||
Connection Name |
mandatory |
Name of the database connection. |
semi-expression |
<executable class="com.ataccama.adt.task.exec.EwfWaitForSqlRowTask">
<pollingInterval>200</pollingInterval>
<timeout>20000</timeout>
<query>select $#{fieldName} from $#{tableName} where $#{checkColumnName} = ${checkColumnValue}</query>
<connectionName>derbyDb</connectionName>
</executable>
Was this page useful?