you could save the results of the select all into a text file
Give that text file to a "cvs data set config" and a thread looping through
all the records in the config file
Try this sample jmx script below:
<----- Start -->
<jmeterTestPlan version="1.2" properties="1.8">
<hashTree>
<TestPlan guiclass="TestPlanGui" testclass="TestPlan" testname="Test
Plan" enabled="true">
<elementProp name="TestPlan.user_defined_variables"
elementType="Arguments" guiclass="ArgumentsPanel" testclass="Arguments"
testname="User Defined Variables" enabled="true">
<collectionProp name="Arguments.arguments"/>
</elementProp>
<stringProp name="TestPlan.user_define_classpath"></stringProp>
<boolProp name="TestPlan.serialize_threadgroups">true</boolProp>
<boolProp name="TestPlan.functional_mode">false</boolProp>
<stringProp name="TestPlan.comments"></stringProp>
</TestPlan>
<hashTree>
<Arguments guiclass="ArgumentsPanel" testclass="Arguments"
testname="globalVariables" enabled="true">
<collectionProp name="Arguments.arguments">
<elementProp name="countRows" elementType="Argument">
<stringProp name="Argument.metadata">=</stringProp>
<stringProp name="Argument.value">0</stringProp>
<stringProp name="Argument.name">countRows</stringProp>
</elementProp>
</collectionProp>
</Arguments>
<hashTree/>
<ThreadGroup guiclass="ThreadGroupGui" testclass="ThreadGroup"
testname="Thread Group" enabled="true">
<longProp name="ThreadGroup.start_time">1127346244000</longProp>
<stringProp name="ThreadGroup.delay"></stringProp>
<stringProp name="ThreadGroup.duration"></stringProp>
<stringProp name="ThreadGroup.num_threads">1</stringProp>
<boolProp name="ThreadGroup.scheduler">false</boolProp>
<elementProp name="ThreadGroup.main_controller"
elementType="LoopController" guiclass="LoopControlPanel"
testclass="LoopController" testname="Loop Controller" enabled="true">
<stringProp name="LoopController.loops">1</stringProp>
<boolProp name="LoopController.continue_forever">false</boolProp>
</elementProp>
<longProp name="ThreadGroup.end_time">1127346244000</longProp>
<stringProp name="ThreadGroup.on_sample_error">continue</stringProp>
<stringProp name="ThreadGroup.ramp_time">1</stringProp>
</ThreadGroup>
<hashTree>
<JDBCDataSource guiclass="TestBeanGUI" testclass="JDBCDataSource"
testname="JDBC Connection Configuration" enabled="true">
<stringProp name="password"></stringProp>
<stringProp name="timeout">10000</stringProp>
<stringProp name="checkQuery">Select 1</stringProp>
<stringProp name="trimInterval">60000</stringProp>
<boolProp name="autocommit">true</boolProp>
<stringProp name="poolMax">10</stringProp>
<stringProp name="driver">com.mysql.jdbc.Driver</stringProp>
<stringProp name="connectionAge">5000</stringProp>
<stringProp name="dataSource">mysql</stringProp>
<boolProp name="keepAlive">true</boolProp>
<stringProp name="username">root</stringProp>
<stringProp
name="dbUrl">jdbc:mysql://localhost:3306/todoApp_development</stringProp>
</JDBCDataSource>
<hashTree/>
<JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler"
testname="getAllRecords" enabled="true">
<stringProp name="dataSource">mysql</stringProp>
<stringProp name="queryType">Select Statement</stringProp>
<stringProp name="query">select * from todos;</stringProp>
</JDBCSampler>
<hashTree>
<BeanShellListener guiclass="TestBeanGUI"
testclass="BeanShellListener" testname="SaveRecordsTofile" enabled="true">
<stringProp name="script">
try {
FileWriter responseFile = new FileWriter(
"database_response.txt");
String response = sampleResult.getResponseDataAsString();
log.info("response = " + sampleResult.getResponseDataAsString());
log.info("countRows = " + vars.get("countRows"));
responseFile.write(response);
responseFile.close();
} catch (IOException io) {
log.error("Problem writing to response file " +responseFile,
io);
}
</stringProp>
</BeanShellListener>
<hashTree/>
</hashTree>
<ThreadGroup guiclass="ThreadGroupGui" testclass="ThreadGroup"
testname="RunForEachRecord" enabled="true">
<longProp name="ThreadGroup.start_time">1127346244000</longProp>
<stringProp name="ThreadGroup.delay"></stringProp>
<stringProp name="ThreadGroup.duration"></stringProp>
<stringProp name="ThreadGroup.num_threads">1</stringProp>
<boolProp name="ThreadGroup.scheduler">false</boolProp>
<elementProp name="ThreadGroup.main_controller"
elementType="LoopController" guiclass="LoopControlPanel"
testclass="LoopController" testname="Loop Controller" enabled="true">
<stringProp name="LoopController.loops">1</stringProp>
<boolProp
name="LoopController.continue_forever">false</boolProp>
</elementProp>
<longProp name="ThreadGroup.end_time">1127346244000</longProp>
<stringProp
name="ThreadGroup.on_sample_error">continue</stringProp>
<stringProp name="ThreadGroup.ramp_time">1</stringProp>
</ThreadGroup>
<hashTree>
<CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet"
testname="CSV Data Set Config" enabled="true">
<stringProp name="delimiter">\t</stringProp>
<stringProp name="variableNames">id1,name1,user_id1</stringProp>
<boolProp name="recycle">false</boolProp>
<stringProp name="filename">G:\Installers and
Softwares\jakarta-jmeter-2.2\bin\database_response.txt</stringProp>
</CSVDataSet>
<hashTree/>
<LoopController guiclass="LoopControlPanel"
testclass="LoopController" testname="Loop Controller" enabled="true">
<stringProp name="LoopController.loops">1</stringProp>
<boolProp name="LoopController.continue_forever">true</boolProp>
</LoopController>
<hashTree>
<HTTPSampler guiclass="HttpTestSampleGui"
testclass="HTTPSampler" testname="HTTP Request" enabled="true">
<stringProp name="HTTPSampler.path">check</stringProp>
<stringProp name="HTTPSampler.method">GET</stringProp>
<boolProp name="HTTPSampler.use_keepalive">true</boolProp>
<stringProp name="HTTPSampler.protocol"></stringProp>
<boolProp name="HTTPSampler.follow_redirects">true</boolProp>
<stringProp name="HTTPSampler.port"></stringProp>
<elementProp name="HTTPsampler.Arguments"
elementType="Arguments" guiclass="HTTPArgumentsPanel" testclass="Arguments"
testname="User Defined Variables" enabled="true">
<collectionProp name="Arguments.arguments">
<elementProp name="" elementType="HTTPArgument">
<stringProp name="Argument.metadata">=</stringProp>
<stringProp name="Argument.value">${id1}</stringProp>
<boolProp name="HTTPArgument.use_equals">true</boolProp>
<stringProp name="Argument.name">id</stringProp>
<boolProp
name="HTTPArgument.always_encode">false</boolProp>
</elementProp>
<elementProp name="" elementType="HTTPArgument">
<stringProp name="Argument.metadata">=</stringProp>
<stringProp name="Argument.value">${name1}</stringProp>
<boolProp name="HTTPArgument.use_equals">true</boolProp>
<stringProp name="Argument.name">name</stringProp>
<boolProp
name="HTTPArgument.always_encode">false</boolProp>
</elementProp>
<elementProp name="" elementType="HTTPArgument">
<stringProp name="Argument.metadata">=</stringProp>
<stringProp
name="Argument.value">${user_id1}</stringProp>
<boolProp name="HTTPArgument.use_equals">true</boolProp>
<stringProp name="Argument.name">user_id</stringProp>
<boolProp
name="HTTPArgument.always_encode">false</boolProp>
</elementProp>
</collectionProp>
</elementProp>
<stringProp name="HTTPSampler.mimetype"></stringProp>
<stringProp name="HTTPSampler.FILE_FIELD"></stringProp>
<stringProp name="HTTPSampler.monitor">false</stringProp>
<stringProp name="HTTPSampler.domain">localhost</stringProp>
<stringProp name="HTTPSampler.FILE_NAME"></stringProp>
<boolProp name="HTTPSampler.auto_redirects">false</boolProp>
</HTTPSampler>
<hashTree/>
</hashTree>
</hashTree>
</hashTree>
<ResultCollector guiclass="ViewResultsFullVisualizer"
testclass="ResultCollector" testname="View Results Tree" enabled="true">
<objProp>
<value class="SampleSaveConfiguration">
<time>true</time>
<latency>true</latency>
<timestamp>true</timestamp>
<success>true</success>
<label>true</label>
<code>true</code>
<message>true</message>
<threadName>true</threadName>
<dataType>true</dataType>
<encoding>false</encoding>
<assertions>true</assertions>
<subresults>true</subresults>
<responseData>true</responseData>
<samplerData>false</samplerData>
<xml>false</xml>
<fieldNames>false</fieldNames>
<responseHeaders>false</responseHeaders>
<requestHeaders>false</requestHeaders>
<responseDataOnError>true</responseDataOnError>
<saveAssertionResultsFailureMessage>false</saveAssertionResultsFailureMessage>
<assertionsResultsToSave>0</assertionsResultsToSave>
</value>
<name>saveConfig</name>
</objProp>
<stringProp name="filename"></stringProp>
<boolProp name="ResultCollector.error_logging">false</boolProp>
</ResultCollector>
<hashTree/>
</hashTree>
</hashTree>
</jmeterTestPlan>
<----- End --->
Regards,
Avishek
Manjula Priyantha-2 wrote:
>
> Hi All,
>
>
>
> My goal is to perform following goals;
>
>
>
> 1. Query a database and fetch user names & passwords
> 2. Using resulted user names & passwords, perform a load test
>
>
>
> I was able to query a Oracle database and get the resulted query. Then
> used
> Regular Expression Extractor to separate results into 2 variables.
>
> Now I want to use those each and every [user name/password] set to perform
> my load test, Pls. give me a way to proceed. (I have used "Match No."
> parameter in Reg. Ex. Extractor to use one of them, but can't locate the
> way
> of using them one by one)
>
>
>
> BR,
>
> Manjula
>
>
>
--
View this message in context:
http://www.nabble.com/Using-Regular-Expression-Extractor-tf4192598.html#a11923527
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
