Le 13/09/2010 09:38, Jens Müller a ecrit :
>> With a Jmeter properties and SQL query with parameter to select data for
>> each client, that will works (not tested)
>>
>> Ex: SELECT ID, NAME, DATA1, etc FROM MY_TABLE WHERE ID_CLIENT =
>> ${MY_PROPERTIE}
>>
> Ok so far, however my central requirement was that the same data is not used
> even on a later separate test execution.
>
> Could you use a DELETE FROM / UPDATE statement to delete the values from the
> database that were actually used?
>
You can insert a new JDBC sampler to do a SQL DELETE or UPDATE in your
scenario after using the current row data
ex: UPDATE MY_TABLE SET USED = 1 WHERE ID_CLIENT = ${MY_PROPERTIES}
Milamber
> Jens
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
