the idea is like this:
1. do a JDBC request like:
SELECT ("field=" + field) as field FROM table;
As result in ResponseData you will have:
field=<data>
2. use "Post Beanshell" sample in the JDBC to extract data by template:
"field=(.+)"
If you have more then 1 field - then use for all fields the extract template
as "field1=(.+\r)",
"field2=(.+\r)", and etc
\r - means that the data are "tab" delimited.
For the last field use a template like - "fieldN=(.+)"
I think it will help you.
Yaroslav
EvilPeanut wrote:
>
> Hi yaroslav1
>
> I would be very interested in more detail. Do you by chance have an
> example of this? I'm trying to get this working within the next few hours,
> so I'm pretty desperate to get this done ASAP. Sorry if it seems like I'm
> just grabbing at straws.
>
> Thanks in Advance
>
>
> yaroslav1 wrote:
>>
>> Hi Paul-the-hat,
>>
>> You can use some tricky technique to get your goal. You need to update
>> SELECT statement to use your defined column names with printing each of
>> them in new line. Once you reach this result you can just simply use
>> post-regular-expression-extractor to create variables for them.
>> If you need more detail, let me know.
>>
>> Happy New Years everybody!
>>
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/JDBC-Request%3A-Select-returning-values-to-variables-tp20931986p21524862.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
