I have configured JDBC connection to mysql.
And I have added the JDBC sampler and a listener.
But I wanted to extract the details with regular expression extractor and then to enter into a foreach loop.
In ForEach loop, I wanted to execute a HTTP request.
My results window look as:
empid empname empDesgination
10 lee jrtester
10 lee MURAEE
123 lee MURAEE
1234567890 leeee MURALEE
1234567890 lee MURALEE
Please explain the following points:
- How to write Regular Expression Extractor(i.e.. Regular Expression)?
- How to extract from that?
- What should I enter in ForEach loop Input Variable and in Output Varible?
As, with the information provided, i have worked on the JDBC, but it doesn't extracting the data and entering into loop. Could u please Explain what Exactly Regex expression we write to extract the above data. Where we give the Reference name as ${VAR_out}
for Http request sampler. Please expalin me the full flow with Regex, ForEach and Http Sampler.
Please provide me simple example on JDBC sampler Extracting data using Regular Expression Extractor and entering into the ForEach Loop.