jakarta-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Milamber <milam...@apache.org>
Subject Re: [JMeter] Extending JMeter: Shared Data Set
Date Mon, 13 Sep 2010 21:42:42 GMT


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: dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: dev-help@jakarta.apache.org
>
>
>   


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: dev-help@jakarta.apache.org


Mime
View raw message