Thank you Sebb, this is highly appreciated.
Thanks and kind regards Benedict Nkosi Performance Tester -----Original Message----- From: sebb [mailto:seb...@gmail.com] Sent: 26 May 2011 12:44 PM To: JMeter Users List Subject: Re: User Parameter variable in JDBC Connection Configuration On 26 May 2011 11:36, <benedict.nk...@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:seb...@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.nk...@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-unsubscr...@jakarta.apache.org >> For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org > For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org > For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org
