web services - jmeter: soap/xml-rpc request with jdbc preprocessor -

i'm trying build jmeter (v2.12) test plan call web service. i'm using soap/xml-rpc request sampler in order it. but, 1 argument of request must dynamic, , thinking using jdbc preprocessor.

i'm able execute soap request, it's working, i'm not able make dynamic, passing values extracted jdbc preprocessor.

my test plan looks like:

the jdbc connection configuration looks like:

then, defined jdbc preprocessor as:

and soap request looks like:

notice modified soap request , included ${id}, but, when run test plan, web service returns error telling unmarshalling error: input string: "${id}". so, can see, jmeter did not replaced variable return database.

so, question is, how do kind of test plan (dynamic soap/xml-rcp request jdbc preprocessor)?

as per user manual

if variable names list provided, each row returned select statement, variables set value of corresponding column (if variable name provided), , count of rows set up. example, if select statement returns 2 rows of 3 columns, , variable list a,,c, following variables set up:

a_#=2 (number of rows) a_1=column 1, row 1 a_2=column 1, row 2 c_#=2 (number of rows) c_1=column 3, row 1 c_2=column 3, row 2 

so if query returns single number need use ${id_1} "dynamicfield" parameter

see the real secret building database test plan jmeter guide more details on how perform database operations apache jmeter.