jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sebb <seb...@gmail.com>
Subject Re: User Parameter variable in JDBC Connection Configuration
Date Thu, 26 May 2011 10:43:36 GMT
On 26 May 2011 11:36,  <Benedict.Nkosi@sungard.com> wrote:
> Thank Sebb, it works.
>
> Since I was using CSV Data Set Config for my parameter, I had to define
> the parameter :@${ipAddressParameter} in the test plan level and use the
> ${__StringFromFile(Server.dat,pServerParam,,)} function to read from a
> text file with just the server IP address in it.
>
> Is there a way to use this function to read from a CSV with multiple
> columns using delimiters?

http://jakarta.apache.org/jmeter/usermanual/functions.html#__split

Or you can use a properties file instead to define the values.
This can be passed in via the -q option and then use the __P()
function to define the variable (or on the JDBC config).

> Thanks and kind regards
> Benedict Nkosi
> Performance Tester
>
>
> -----Original Message-----
> From: sebb [mailto:sebbaz@gmail.com]
> Sent: 26 May 2011 12:16 PM
> To: JMeter Users List
> Subject: Re: User Parameter variable in JDBC Connection Configuration
>
> On 26 May 2011 10:37,  <Benedict.Nkosi@sungard.com> wrote:
>> I want to use User Parameter variable within Database URL under JDBC
>> Connection Configuration. The connection work fine without parameters
>> but as soon as I parametize the Server IP address I get an error. Does
>> the JDBC Connection Configuration support parameters.
>>
>> Works.
>> jdbc:oracle:thin:@ipAddress:1521:EMS102VM
>>
>> doesn't work.
>> jdbc:oracle:thin:@${ipAddressParameter}:1521:EMS102VM
>>
>
> If the variable is not being replaced, then it is not defined *at the
> point of use*.
>
> Note that the JDBC Connection config is used very early on in a test.
>
> Try defining the variable on the test plan.
>
>> please help
>>
>>
>> Thanks and kind regards
>> Benedict Nkosi
>> Performance Tester
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>

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


Mime
View raw message