You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Ori Marco <or...@praxell.com> on 2008/01/27 14:24:29 UTC
Dynamic JDBC configuration (user&pass)
Hi
How can I use dynamic username and password in JDBC connection
configuration?
If it's possible can database URL be dynamic?
Thanks
Ori Marko
Quality Assurance Engineer
Praxell Inc.
http://www.praxell.com <http://www.praxell.com>
Re: Dynamic JDBC configuration (user&pass)
Posted by sebb <se...@gmail.com>.
See my posting of June 16th
On 02/07/2008, Ori Marco <or...@praxell.com> wrote:
> Is it possible to use few pools w/ different names
> And for each JDBC request use variable that will be decided in runtime?
>
>
> Thanks
>
> Ori Marko
> Quality Assurance Engineer
> Praxell Inc.
> http://www.praxell.com
>
>
> -----Original Message-----
> From: sebb [mailto:sebbaz@gmail.com]
>
> Sent: Saturday, June 14, 2008 3:19 AM
> To: JMeter Users List
> Subject: Re: Dynamic JDBC configuration (user&pass)
>
> On 13/06/2008, Simon De Uvarow <sd...@gmail.com> wrote:
> > Hello Sebb .. i was reading this because i want to do the same than
> Ori, but
> > for a different reason .. I want to test a DB using the JDBC Sampler
> .. but
> > it seems is not possible to connect each thread with different
> user/password
> > ... am i right?
> >
>
> Yes.
>
> I don't think it's possible currently, and unfortunately looks to be
> difficult to fix, as it seems a reasonable requirement.
>
> >
> > "No olvides, no traiciones, lo que llevas bien dentro de ti. No
> olvides, no
> > traiciones, lo que siempre te ha hecho vivir."
> >
> >
> > On Sun, Jan 27, 2008 at 12:52 PM, sebb <se...@gmail.com> wrote:
> >
> > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > In database connection configuration there are username,password
> and url
> > > > I want to be able to get those parameters from Main DB so I can
> run
> > > > using same JMX tests on several DBs/Configurations.
> > > >
> > >
> > > Ah, now it becomes clear.
> > >
> > > > It seems that this can't be done except sending in command-line.
> > > >
> > >
> > > The JDBC Config element is only processed at test startup, so it is
> > > not possible to change the values once a test has started - i.e.
> you
> > > could not change the values for different loops of the test plan.
> The
> > > test plan has to know the JDBC settings near the start.
> > >
> > > You may be able to use the StringFromFile or CSVRead functions as
> > > input to JDBC config; I've not tried.
> > >
> > > But the simplest is going to be using properties on the
> command-line.
> > >
> > > > Ori Marko
> > > > Quality Assurance Engineer
> > > > Praxell Inc.
> > > > http://www.praxell.com
> > > >
> > > > -----Original Message-----
> > > > From: sebb [mailto:sebbaz@gmail.com]
> > > > Sent: Sunday, January 27, 2008 5:19 PM
> > > > To: JMeter Users List
> > > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > > >
> > > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > > Hi
> > > > >
> > > > > The problem remains, I want to change user/pass variables
> according to
> > > > > values in DB.
> > > >
> > > > Which user / password are you talking about here?
> > > >
> > > > I assume that you need a user and pass to connect to the DB in
> the
> > > > first place ...
> > > >
> > > > > But JDBC Config element is setting its variables at the start
> of the
> > > > > test.
> > > >
> > > > It does not set variables, but it does read the values (which may
> be
> > > > variables) that define the connection quite early in the test.
> > > >
> > > > > So I must send user/pass in command-line as properties or
> define in
> > > > JMX,
> > > > > right?
> > > >
> > > > Depends which user/pass you are referring to.
> > > >
> > > > Please clarify exactly what you are trying to do.
> > > >
> > > > > Ori Marko
> > > > > Quality Assurance Engineer
> > > > > Praxell Inc.
> > > > > http://www.praxell.com
> > > > >
> > > > > -----Original Message-----
> > > > > From: sebb [mailto:sebbaz@gmail.com]
> > > > > Sent: Sunday, January 27, 2008 4:49 PM
> > > > > To: JMeter Users List
> > > > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > > > >
> > > > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > > > The problem is that I need to get dynamically the user/pass
> > > > > > If it's defined in Test Plan it's not dynamic
> > > > >
> > > > > Not strictly true - you can define variables as property
> references,
> > > > > and pass in the properties via the command line.
> > > > >
> > > > > > It seems that what was defined in Test Plan can't be override
> after
> > > > > test
> > > > > > has started
> > > > > > (changing variable value in runtime doesn't change user/pass
> of JDBC
> > > > > > connection)
> > > > >
> > > > > That's not true - variables defined on the test plan can be
> changed;
> > > > > however if they are changed after the JDBC Config element has
> used
> > > > > them, the change will have no effect. That's what happens with
> the CSV
> > > > > Dataset.
> > > > >
> > > > > > Ori Marko
> > > > > > Quality Assurance Engineer
> > > > > > Praxell Inc.
> > > > > > http://www.praxell.com
> > > > > >
> > > > > > -----Original Message-----
> > > > > > From: sebb [mailto:sebbaz@gmail.com]
> > > > > > Sent: Sunday, January 27, 2008 4:17 PM
> > > > > > To: JMeter Users List
> > > > > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > > > > >
> > > > > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > > > > Hi
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > How can I use dynamic username and password in JDBC
> connection
> > > > > > > configuration?
> > > > > >
> > > > > > As normal, just use the variable references.
> > > > > >
> > > > > > > If it's possible can database URL be dynamic?
> > > > > > >
> > > > > >
> > > > > > Have you tried?
> > > > > >
> > > > > > Note that the JDBC config element is processed early on, so
> CSV
> > > > > > Dataset variables cannot be used, see the note here:
> > > > > >
> > > > > >
> > > > >
> > > >
> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#CSV
> > > > > > _Data_Set_Config
> > > > > >
> > > > > > I suggest you try replacing the fixed strings with variables
> defined
> > > > > > on the Test Plan. You can then try other methods of defining
> the
> > > > > > variables.
> > > > > >
> > > > > > >
> > > > > > > Thanks
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Ori Marko
> > > > > > > Quality Assurance Engineer
> > > > > > > Praxell Inc.
> > > > > > > http://www.praxell.com <http://www.praxell.com>
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > >
> ---------------------------------------------------------------------
> > > > > > 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
> > > > >
> > > > >
> > > >
> > > >
> ---------------------------------------------------------------------
> > > > 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
>
>
> ---------------------------------------------------------------------
> 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
RE: Dynamic JDBC configuration (user&pass)
Posted by Ori Marco <or...@praxell.com>.
Is it possible to use few pools w/ different names
And for each JDBC request use variable that will be decided in runtime?
Thanks
Ori Marko
Quality Assurance Engineer
Praxell Inc.
http://www.praxell.com
-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com]
Sent: Saturday, June 14, 2008 3:19 AM
To: JMeter Users List
Subject: Re: Dynamic JDBC configuration (user&pass)
On 13/06/2008, Simon De Uvarow <sd...@gmail.com> wrote:
> Hello Sebb .. i was reading this because i want to do the same than
Ori, but
> for a different reason .. I want to test a DB using the JDBC Sampler
.. but
> it seems is not possible to connect each thread with different
user/password
> ... am i right?
>
Yes.
I don't think it's possible currently, and unfortunately looks to be
difficult to fix, as it seems a reasonable requirement.
>
> "No olvides, no traiciones, lo que llevas bien dentro de ti. No
olvides, no
> traiciones, lo que siempre te ha hecho vivir."
>
>
> On Sun, Jan 27, 2008 at 12:52 PM, sebb <se...@gmail.com> wrote:
>
> > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > In database connection configuration there are username,password
and url
> > > I want to be able to get those parameters from Main DB so I can
run
> > > using same JMX tests on several DBs/Configurations.
> > >
> >
> > Ah, now it becomes clear.
> >
> > > It seems that this can't be done except sending in command-line.
> > >
> >
> > The JDBC Config element is only processed at test startup, so it is
> > not possible to change the values once a test has started - i.e.
you
> > could not change the values for different loops of the test plan.
The
> > test plan has to know the JDBC settings near the start.
> >
> > You may be able to use the StringFromFile or CSVRead functions as
> > input to JDBC config; I've not tried.
> >
> > But the simplest is going to be using properties on the
command-line.
> >
> > > Ori Marko
> > > Quality Assurance Engineer
> > > Praxell Inc.
> > > http://www.praxell.com
> > >
> > > -----Original Message-----
> > > From: sebb [mailto:sebbaz@gmail.com]
> > > Sent: Sunday, January 27, 2008 5:19 PM
> > > To: JMeter Users List
> > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > >
> > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > Hi
> > > >
> > > > The problem remains, I want to change user/pass variables
according to
> > > > values in DB.
> > >
> > > Which user / password are you talking about here?
> > >
> > > I assume that you need a user and pass to connect to the DB in
the
> > > first place ...
> > >
> > > > But JDBC Config element is setting its variables at the start
of the
> > > > test.
> > >
> > > It does not set variables, but it does read the values (which may
be
> > > variables) that define the connection quite early in the test.
> > >
> > > > So I must send user/pass in command-line as properties or
define in
> > > JMX,
> > > > right?
> > >
> > > Depends which user/pass you are referring to.
> > >
> > > Please clarify exactly what you are trying to do.
> > >
> > > > Ori Marko
> > > > Quality Assurance Engineer
> > > > Praxell Inc.
> > > > http://www.praxell.com
> > > >
> > > > -----Original Message-----
> > > > From: sebb [mailto:sebbaz@gmail.com]
> > > > Sent: Sunday, January 27, 2008 4:49 PM
> > > > To: JMeter Users List
> > > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > > >
> > > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > > The problem is that I need to get dynamically the user/pass
> > > > > If it's defined in Test Plan it's not dynamic
> > > >
> > > > Not strictly true - you can define variables as property
references,
> > > > and pass in the properties via the command line.
> > > >
> > > > > It seems that what was defined in Test Plan can't be override
after
> > > > test
> > > > > has started
> > > > > (changing variable value in runtime doesn't change user/pass
of JDBC
> > > > > connection)
> > > >
> > > > That's not true - variables defined on the test plan can be
changed;
> > > > however if they are changed after the JDBC Config element has
used
> > > > them, the change will have no effect. That's what happens with
the CSV
> > > > Dataset.
> > > >
> > > > > Ori Marko
> > > > > Quality Assurance Engineer
> > > > > Praxell Inc.
> > > > > http://www.praxell.com
> > > > >
> > > > > -----Original Message-----
> > > > > From: sebb [mailto:sebbaz@gmail.com]
> > > > > Sent: Sunday, January 27, 2008 4:17 PM
> > > > > To: JMeter Users List
> > > > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > > > >
> > > > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > > > Hi
> > > > > >
> > > > > >
> > > > > >
> > > > > > How can I use dynamic username and password in JDBC
connection
> > > > > > configuration?
> > > > >
> > > > > As normal, just use the variable references.
> > > > >
> > > > > > If it's possible can database URL be dynamic?
> > > > > >
> > > > >
> > > > > Have you tried?
> > > > >
> > > > > Note that the JDBC config element is processed early on, so
CSV
> > > > > Dataset variables cannot be used, see the note here:
> > > > >
> > > > >
> > > >
> > >
http://jakarta.apache.org/jmeter/usermanual/component_reference.html#CSV
> > > > > _Data_Set_Config
> > > > >
> > > > > I suggest you try replacing the fixed strings with variables
defined
> > > > > on the Test Plan. You can then try other methods of defining
the
> > > > > variables.
> > > > >
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > >
> > > > > >
> > > > > > Ori Marko
> > > > > > Quality Assurance Engineer
> > > > > > Praxell Inc.
> > > > > > http://www.praxell.com <http://www.praxell.com>
> > > > > >
> > > > > >
> > > > >
> > > > >
> > >
---------------------------------------------------------------------
> > > > > 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
> > > >
> > > >
> > >
> > >
---------------------------------------------------------------------
> > > 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
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Dynamic JDBC configuration (user&pass)
Posted by sebb <se...@gmail.com>.
On 16/06/2008, Simon De Uvarow <sd...@ces.com.uy> wrote:
> OK, thanks. I discuss the problem with my coworkers, and we conclude that,
> in this case, we want to simulate the load made by a application server, not
> by a group of users.
>
> And the appl. servers use one user and a connection pool .. so, it's good
> for the test.
>
> I think, in the case of a user group doing things in a DB .. it could be
> solved with a program that run several JMeter instances with the same
> TestPlan (if the users do the same in the DB), but changing the user in the
> connection ... it is a hard workaround .. but is a possibility..
>
I don't think it's very difficult - just define the user name and
password using the __P() function, and pass the properties on the
command-line.
There is another possible work-round:
If there aren't too many different users involved - e.g. 10 or fewer -
then one could set up a JDBC Config element for each user/password.
Name the pools USER1 ... USER10. The Max number of connections must be
set to 0 to ensure a single connection per thread.
The JDBC Request can use a variable for the pool name, e.g.
USER${__threadNum} would work if there were 10 threads in total. Or
the thread could read the pool name from a file.
The JDBC Config element cannot be configured in the same way - it has
to use values that are fixed when it is processed at the start of the
test.
> regards!
>
> Simon
>
>
>
> "No olvides, no traiciones, lo que llevas bien dentro de ti. No olvides, no
> traiciones, lo que siempre te ha hecho vivir."
>
>
> On Fri, Jun 13, 2008 at 9:18 PM, sebb <se...@gmail.com> wrote:
>
> > On 13/06/2008, Simon De Uvarow <sd...@gmail.com> wrote:
> > > Hello Sebb .. i was reading this because i want to do the same than Ori,
> > but
> > > for a different reason .. I want to test a DB using the JDBC Sampler ..
> > but
> > > it seems is not possible to connect each thread with different
> > user/password
> > > ... am i right?
> > >
> >
> > Yes.
> >
> > I don't think it's possible currently, and unfortunately looks to be
> > difficult to fix, as it seems a reasonable requirement.
> >
> > >
> > > "No olvides, no traiciones, lo que llevas bien dentro de ti. No olvides,
> > no
> > > traiciones, lo que siempre te ha hecho vivir."
> > >
> > >
> > > On Sun, Jan 27, 2008 at 12:52 PM, sebb <se...@gmail.com> wrote:
> > >
> > > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > > In database connection configuration there are username,password and
> > url
> > > > > I want to be able to get those parameters from Main DB so I can run
> > > > > using same JMX tests on several DBs/Configurations.
> > > > >
> > > >
> > > > Ah, now it becomes clear.
> > > >
> > > > > It seems that this can't be done except sending in command-line.
> > > > >
> > > >
> > > > The JDBC Config element is only processed at test startup, so it is
> > > > not possible to change the values once a test has started - i.e. you
> > > > could not change the values for different loops of the test plan. The
> > > > test plan has to know the JDBC settings near the start.
> > > >
> > > > You may be able to use the StringFromFile or CSVRead functions as
> > > > input to JDBC config; I've not tried.
> > > >
> > > > But the simplest is going to be using properties on the command-line.
> > > >
> > > > > Ori Marko
> > > > > Quality Assurance Engineer
> > > > > Praxell Inc.
> > > > > http://www.praxell.com
> > > > >
> > > > > -----Original Message-----
> > > > > From: sebb [mailto:sebbaz@gmail.com]
> > > > > Sent: Sunday, January 27, 2008 5:19 PM
> > > > > To: JMeter Users List
> > > > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > > > >
> > > > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > > > Hi
> > > > > >
> > > > > > The problem remains, I want to change user/pass variables
> > according to
> > > > > > values in DB.
> > > > >
> > > > > Which user / password are you talking about here?
> > > > >
> > > > > I assume that you need a user and pass to connect to the DB in the
> > > > > first place ...
> > > > >
> > > > > > But JDBC Config element is setting its variables at the start of
> > the
> > > > > > test.
> > > > >
> > > > > It does not set variables, but it does read the values (which may be
> > > > > variables) that define the connection quite early in the test.
> > > > >
> > > > > > So I must send user/pass in command-line as properties or define
> > in
> > > > > JMX,
> > > > > > right?
> > > > >
> > > > > Depends which user/pass you are referring to.
> > > > >
> > > > > Please clarify exactly what you are trying to do.
> > > > >
> > > > > > Ori Marko
> > > > > > Quality Assurance Engineer
> > > > > > Praxell Inc.
> > > > > > http://www.praxell.com
> > > > > >
> > > > > > -----Original Message-----
> > > > > > From: sebb [mailto:sebbaz@gmail.com]
> > > > > > Sent: Sunday, January 27, 2008 4:49 PM
> > > > > > To: JMeter Users List
> > > > > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > > > > >
> > > > > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > > > > The problem is that I need to get dynamically the user/pass
> > > > > > > If it's defined in Test Plan it's not dynamic
> > > > > >
> > > > > > Not strictly true - you can define variables as property
> > references,
> > > > > > and pass in the properties via the command line.
> > > > > >
> > > > > > > It seems that what was defined in Test Plan can't be override
> > after
> > > > > > test
> > > > > > > has started
> > > > > > > (changing variable value in runtime doesn't change user/pass of
> > JDBC
> > > > > > > connection)
> > > > > >
> > > > > > That's not true - variables defined on the test plan can be
> > changed;
> > > > > > however if they are changed after the JDBC Config element has used
> > > > > > them, the change will have no effect. That's what happens with the
> > CSV
> > > > > > Dataset.
> > > > > >
> > > > > > > Ori Marko
> > > > > > > Quality Assurance Engineer
> > > > > > > Praxell Inc.
> > > > > > > http://www.praxell.com
> > > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: sebb [mailto:sebbaz@gmail.com]
> > > > > > > Sent: Sunday, January 27, 2008 4:17 PM
> > > > > > > To: JMeter Users List
> > > > > > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > > > > > >
> > > > > > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > > > > > Hi
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > How can I use dynamic username and password in JDBC connection
> > > > > > > > configuration?
> > > > > > >
> > > > > > > As normal, just use the variable references.
> > > > > > >
> > > > > > > > If it's possible can database URL be dynamic?
> > > > > > > >
> > > > > > >
> > > > > > > Have you tried?
> > > > > > >
> > > > > > > Note that the JDBC config element is processed early on, so CSV
> > > > > > > Dataset variables cannot be used, see the note here:
> > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > http://jakarta.apache.org/jmeter/usermanual/component_reference.html#CSV
> > > > > > > _Data_Set_Config
> > > > > > >
> > > > > > > I suggest you try replacing the fixed strings with variables
> > defined
> > > > > > > on the Test Plan. You can then try other methods of defining the
> > > > > > > variables.
> > > > > > >
> > > > > > > >
> > > > > > > > Thanks
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Ori Marko
> > > > > > > > Quality Assurance Engineer
> > > > > > > > Praxell Inc.
> > > > > > > > http://www.praxell.com <http://www.praxell.com>
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > ---------------------------------------------------------------------
> > > > > > > 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
> > > > > >
> > > > > >
> > > > >
> > > > >
> > ---------------------------------------------------------------------
> > > > > 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
> >
> >
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Dynamic JDBC configuration (user&pass)
Posted by Simon De Uvarow <sd...@ces.com.uy>.
OK, thanks. I discuss the problem with my coworkers, and we conclude that,
in this case, we want to simulate the load made by a application server, not
by a group of users.
And the appl. servers use one user and a connection pool .. so, it's good
for the test.
I think, in the case of a user group doing things in a DB .. it could be
solved with a program that run several JMeter instances with the same
TestPlan (if the users do the same in the DB), but changing the user in the
connection ... it is a hard workaround .. but is a possibility..
regards!
Simon
"No olvides, no traiciones, lo que llevas bien dentro de ti. No olvides, no
traiciones, lo que siempre te ha hecho vivir."
On Fri, Jun 13, 2008 at 9:18 PM, sebb <se...@gmail.com> wrote:
> On 13/06/2008, Simon De Uvarow <sd...@gmail.com> wrote:
> > Hello Sebb .. i was reading this because i want to do the same than Ori,
> but
> > for a different reason .. I want to test a DB using the JDBC Sampler ..
> but
> > it seems is not possible to connect each thread with different
> user/password
> > ... am i right?
> >
>
> Yes.
>
> I don't think it's possible currently, and unfortunately looks to be
> difficult to fix, as it seems a reasonable requirement.
>
> >
> > "No olvides, no traiciones, lo que llevas bien dentro de ti. No olvides,
> no
> > traiciones, lo que siempre te ha hecho vivir."
> >
> >
> > On Sun, Jan 27, 2008 at 12:52 PM, sebb <se...@gmail.com> wrote:
> >
> > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > In database connection configuration there are username,password and
> url
> > > > I want to be able to get those parameters from Main DB so I can run
> > > > using same JMX tests on several DBs/Configurations.
> > > >
> > >
> > > Ah, now it becomes clear.
> > >
> > > > It seems that this can't be done except sending in command-line.
> > > >
> > >
> > > The JDBC Config element is only processed at test startup, so it is
> > > not possible to change the values once a test has started - i.e. you
> > > could not change the values for different loops of the test plan. The
> > > test plan has to know the JDBC settings near the start.
> > >
> > > You may be able to use the StringFromFile or CSVRead functions as
> > > input to JDBC config; I've not tried.
> > >
> > > But the simplest is going to be using properties on the command-line.
> > >
> > > > Ori Marko
> > > > Quality Assurance Engineer
> > > > Praxell Inc.
> > > > http://www.praxell.com
> > > >
> > > > -----Original Message-----
> > > > From: sebb [mailto:sebbaz@gmail.com]
> > > > Sent: Sunday, January 27, 2008 5:19 PM
> > > > To: JMeter Users List
> > > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > > >
> > > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > > Hi
> > > > >
> > > > > The problem remains, I want to change user/pass variables
> according to
> > > > > values in DB.
> > > >
> > > > Which user / password are you talking about here?
> > > >
> > > > I assume that you need a user and pass to connect to the DB in the
> > > > first place ...
> > > >
> > > > > But JDBC Config element is setting its variables at the start of
> the
> > > > > test.
> > > >
> > > > It does not set variables, but it does read the values (which may be
> > > > variables) that define the connection quite early in the test.
> > > >
> > > > > So I must send user/pass in command-line as properties or define
> in
> > > > JMX,
> > > > > right?
> > > >
> > > > Depends which user/pass you are referring to.
> > > >
> > > > Please clarify exactly what you are trying to do.
> > > >
> > > > > Ori Marko
> > > > > Quality Assurance Engineer
> > > > > Praxell Inc.
> > > > > http://www.praxell.com
> > > > >
> > > > > -----Original Message-----
> > > > > From: sebb [mailto:sebbaz@gmail.com]
> > > > > Sent: Sunday, January 27, 2008 4:49 PM
> > > > > To: JMeter Users List
> > > > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > > > >
> > > > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > > > The problem is that I need to get dynamically the user/pass
> > > > > > If it's defined in Test Plan it's not dynamic
> > > > >
> > > > > Not strictly true - you can define variables as property
> references,
> > > > > and pass in the properties via the command line.
> > > > >
> > > > > > It seems that what was defined in Test Plan can't be override
> after
> > > > > test
> > > > > > has started
> > > > > > (changing variable value in runtime doesn't change user/pass of
> JDBC
> > > > > > connection)
> > > > >
> > > > > That's not true - variables defined on the test plan can be
> changed;
> > > > > however if they are changed after the JDBC Config element has used
> > > > > them, the change will have no effect. That's what happens with the
> CSV
> > > > > Dataset.
> > > > >
> > > > > > Ori Marko
> > > > > > Quality Assurance Engineer
> > > > > > Praxell Inc.
> > > > > > http://www.praxell.com
> > > > > >
> > > > > > -----Original Message-----
> > > > > > From: sebb [mailto:sebbaz@gmail.com]
> > > > > > Sent: Sunday, January 27, 2008 4:17 PM
> > > > > > To: JMeter Users List
> > > > > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > > > > >
> > > > > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > > > > Hi
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > How can I use dynamic username and password in JDBC connection
> > > > > > > configuration?
> > > > > >
> > > > > > As normal, just use the variable references.
> > > > > >
> > > > > > > If it's possible can database URL be dynamic?
> > > > > > >
> > > > > >
> > > > > > Have you tried?
> > > > > >
> > > > > > Note that the JDBC config element is processed early on, so CSV
> > > > > > Dataset variables cannot be used, see the note here:
> > > > > >
> > > > > >
> > > > >
> > > >
> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#CSV
> > > > > > _Data_Set_Config
> > > > > >
> > > > > > I suggest you try replacing the fixed strings with variables
> defined
> > > > > > on the Test Plan. You can then try other methods of defining the
> > > > > > variables.
> > > > > >
> > > > > > >
> > > > > > > Thanks
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Ori Marko
> > > > > > > Quality Assurance Engineer
> > > > > > > Praxell Inc.
> > > > > > > http://www.praxell.com <http://www.praxell.com>
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > >
> ---------------------------------------------------------------------
> > > > > > 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
> > > > >
> > > > >
> > > >
> > > >
> ---------------------------------------------------------------------
> > > > 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
>
>
Re: Dynamic JDBC configuration (user&pass)
Posted by sebb <se...@gmail.com>.
On 13/06/2008, Simon De Uvarow <sd...@gmail.com> wrote:
> Hello Sebb .. i was reading this because i want to do the same than Ori, but
> for a different reason .. I want to test a DB using the JDBC Sampler .. but
> it seems is not possible to connect each thread with different user/password
> ... am i right?
>
Yes.
I don't think it's possible currently, and unfortunately looks to be
difficult to fix, as it seems a reasonable requirement.
>
> "No olvides, no traiciones, lo que llevas bien dentro de ti. No olvides, no
> traiciones, lo que siempre te ha hecho vivir."
>
>
> On Sun, Jan 27, 2008 at 12:52 PM, sebb <se...@gmail.com> wrote:
>
> > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > In database connection configuration there are username,password and url
> > > I want to be able to get those parameters from Main DB so I can run
> > > using same JMX tests on several DBs/Configurations.
> > >
> >
> > Ah, now it becomes clear.
> >
> > > It seems that this can't be done except sending in command-line.
> > >
> >
> > The JDBC Config element is only processed at test startup, so it is
> > not possible to change the values once a test has started - i.e. you
> > could not change the values for different loops of the test plan. The
> > test plan has to know the JDBC settings near the start.
> >
> > You may be able to use the StringFromFile or CSVRead functions as
> > input to JDBC config; I've not tried.
> >
> > But the simplest is going to be using properties on the command-line.
> >
> > > Ori Marko
> > > Quality Assurance Engineer
> > > Praxell Inc.
> > > http://www.praxell.com
> > >
> > > -----Original Message-----
> > > From: sebb [mailto:sebbaz@gmail.com]
> > > Sent: Sunday, January 27, 2008 5:19 PM
> > > To: JMeter Users List
> > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > >
> > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > Hi
> > > >
> > > > The problem remains, I want to change user/pass variables according to
> > > > values in DB.
> > >
> > > Which user / password are you talking about here?
> > >
> > > I assume that you need a user and pass to connect to the DB in the
> > > first place ...
> > >
> > > > But JDBC Config element is setting its variables at the start of the
> > > > test.
> > >
> > > It does not set variables, but it does read the values (which may be
> > > variables) that define the connection quite early in the test.
> > >
> > > > So I must send user/pass in command-line as properties or define in
> > > JMX,
> > > > right?
> > >
> > > Depends which user/pass you are referring to.
> > >
> > > Please clarify exactly what you are trying to do.
> > >
> > > > Ori Marko
> > > > Quality Assurance Engineer
> > > > Praxell Inc.
> > > > http://www.praxell.com
> > > >
> > > > -----Original Message-----
> > > > From: sebb [mailto:sebbaz@gmail.com]
> > > > Sent: Sunday, January 27, 2008 4:49 PM
> > > > To: JMeter Users List
> > > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > > >
> > > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > > The problem is that I need to get dynamically the user/pass
> > > > > If it's defined in Test Plan it's not dynamic
> > > >
> > > > Not strictly true - you can define variables as property references,
> > > > and pass in the properties via the command line.
> > > >
> > > > > It seems that what was defined in Test Plan can't be override after
> > > > test
> > > > > has started
> > > > > (changing variable value in runtime doesn't change user/pass of JDBC
> > > > > connection)
> > > >
> > > > That's not true - variables defined on the test plan can be changed;
> > > > however if they are changed after the JDBC Config element has used
> > > > them, the change will have no effect. That's what happens with the CSV
> > > > Dataset.
> > > >
> > > > > Ori Marko
> > > > > Quality Assurance Engineer
> > > > > Praxell Inc.
> > > > > http://www.praxell.com
> > > > >
> > > > > -----Original Message-----
> > > > > From: sebb [mailto:sebbaz@gmail.com]
> > > > > Sent: Sunday, January 27, 2008 4:17 PM
> > > > > To: JMeter Users List
> > > > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > > > >
> > > > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > > > Hi
> > > > > >
> > > > > >
> > > > > >
> > > > > > How can I use dynamic username and password in JDBC connection
> > > > > > configuration?
> > > > >
> > > > > As normal, just use the variable references.
> > > > >
> > > > > > If it's possible can database URL be dynamic?
> > > > > >
> > > > >
> > > > > Have you tried?
> > > > >
> > > > > Note that the JDBC config element is processed early on, so CSV
> > > > > Dataset variables cannot be used, see the note here:
> > > > >
> > > > >
> > > >
> > > http://jakarta.apache.org/jmeter/usermanual/component_reference.html#CSV
> > > > > _Data_Set_Config
> > > > >
> > > > > I suggest you try replacing the fixed strings with variables defined
> > > > > on the Test Plan. You can then try other methods of defining the
> > > > > variables.
> > > > >
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > >
> > > > > >
> > > > > > Ori Marko
> > > > > > Quality Assurance Engineer
> > > > > > Praxell Inc.
> > > > > > http://www.praxell.com <http://www.praxell.com>
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > ---------------------------------------------------------------------
> > > > > 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
> > > >
> > > >
> > >
> > > ---------------------------------------------------------------------
> > > 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
Re: Dynamic JDBC configuration (user&pass)
Posted by Simon De Uvarow <sd...@gmail.com>.
Hello Sebb .. i was reading this because i want to do the same than Ori, but
for a different reason .. I want to test a DB using the JDBC Sampler .. but
it seems is not possible to connect each thread with different user/password
... am i right?
"No olvides, no traiciones, lo que llevas bien dentro de ti. No olvides, no
traiciones, lo que siempre te ha hecho vivir."
On Sun, Jan 27, 2008 at 12:52 PM, sebb <se...@gmail.com> wrote:
> On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > In database connection configuration there are username,password and url
> > I want to be able to get those parameters from Main DB so I can run
> > using same JMX tests on several DBs/Configurations.
> >
>
> Ah, now it becomes clear.
>
> > It seems that this can't be done except sending in command-line.
> >
>
> The JDBC Config element is only processed at test startup, so it is
> not possible to change the values once a test has started - i.e. you
> could not change the values for different loops of the test plan. The
> test plan has to know the JDBC settings near the start.
>
> You may be able to use the StringFromFile or CSVRead functions as
> input to JDBC config; I've not tried.
>
> But the simplest is going to be using properties on the command-line.
>
> > Ori Marko
> > Quality Assurance Engineer
> > Praxell Inc.
> > http://www.praxell.com
> >
> > -----Original Message-----
> > From: sebb [mailto:sebbaz@gmail.com]
> > Sent: Sunday, January 27, 2008 5:19 PM
> > To: JMeter Users List
> > Subject: Re: Dynamic JDBC configuration (user&pass)
> >
> > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > Hi
> > >
> > > The problem remains, I want to change user/pass variables according to
> > > values in DB.
> >
> > Which user / password are you talking about here?
> >
> > I assume that you need a user and pass to connect to the DB in the
> > first place ...
> >
> > > But JDBC Config element is setting its variables at the start of the
> > > test.
> >
> > It does not set variables, but it does read the values (which may be
> > variables) that define the connection quite early in the test.
> >
> > > So I must send user/pass in command-line as properties or define in
> > JMX,
> > > right?
> >
> > Depends which user/pass you are referring to.
> >
> > Please clarify exactly what you are trying to do.
> >
> > > Ori Marko
> > > Quality Assurance Engineer
> > > Praxell Inc.
> > > http://www.praxell.com
> > >
> > > -----Original Message-----
> > > From: sebb [mailto:sebbaz@gmail.com]
> > > Sent: Sunday, January 27, 2008 4:49 PM
> > > To: JMeter Users List
> > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > >
> > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > The problem is that I need to get dynamically the user/pass
> > > > If it's defined in Test Plan it's not dynamic
> > >
> > > Not strictly true - you can define variables as property references,
> > > and pass in the properties via the command line.
> > >
> > > > It seems that what was defined in Test Plan can't be override after
> > > test
> > > > has started
> > > > (changing variable value in runtime doesn't change user/pass of JDBC
> > > > connection)
> > >
> > > That's not true - variables defined on the test plan can be changed;
> > > however if they are changed after the JDBC Config element has used
> > > them, the change will have no effect. That's what happens with the CSV
> > > Dataset.
> > >
> > > > Ori Marko
> > > > Quality Assurance Engineer
> > > > Praxell Inc.
> > > > http://www.praxell.com
> > > >
> > > > -----Original Message-----
> > > > From: sebb [mailto:sebbaz@gmail.com]
> > > > Sent: Sunday, January 27, 2008 4:17 PM
> > > > To: JMeter Users List
> > > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > > >
> > > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > > Hi
> > > > >
> > > > >
> > > > >
> > > > > How can I use dynamic username and password in JDBC connection
> > > > > configuration?
> > > >
> > > > As normal, just use the variable references.
> > > >
> > > > > If it's possible can database URL be dynamic?
> > > > >
> > > >
> > > > Have you tried?
> > > >
> > > > Note that the JDBC config element is processed early on, so CSV
> > > > Dataset variables cannot be used, see the note here:
> > > >
> > > >
> > >
> > http://jakarta.apache.org/jmeter/usermanual/component_reference.html#CSV
> > > > _Data_Set_Config
> > > >
> > > > I suggest you try replacing the fixed strings with variables defined
> > > > on the Test Plan. You can then try other methods of defining the
> > > > variables.
> > > >
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > > >
> > > > > Ori Marko
> > > > > Quality Assurance Engineer
> > > > > Praxell Inc.
> > > > > http://www.praxell.com <http://www.praxell.com>
> > > > >
> > > > >
> > > >
> > > >
> > ---------------------------------------------------------------------
> > > > 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
> > >
> > >
> >
> > ---------------------------------------------------------------------
> > 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
>
>
Re: Dynamic JDBC configuration (user&pass)
Posted by sebb <se...@gmail.com>.
On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> In database connection configuration there are username,password and url
> I want to be able to get those parameters from Main DB so I can run
> using same JMX tests on several DBs/Configurations.
>
Ah, now it becomes clear.
> It seems that this can't be done except sending in command-line.
>
The JDBC Config element is only processed at test startup, so it is
not possible to change the values once a test has started - i.e. you
could not change the values for different loops of the test plan. The
test plan has to know the JDBC settings near the start.
You may be able to use the StringFromFile or CSVRead functions as
input to JDBC config; I've not tried.
But the simplest is going to be using properties on the command-line.
> Ori Marko
> Quality Assurance Engineer
> Praxell Inc.
> http://www.praxell.com
>
> -----Original Message-----
> From: sebb [mailto:sebbaz@gmail.com]
> Sent: Sunday, January 27, 2008 5:19 PM
> To: JMeter Users List
> Subject: Re: Dynamic JDBC configuration (user&pass)
>
> On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > Hi
> >
> > The problem remains, I want to change user/pass variables according to
> > values in DB.
>
> Which user / password are you talking about here?
>
> I assume that you need a user and pass to connect to the DB in the
> first place ...
>
> > But JDBC Config element is setting its variables at the start of the
> > test.
>
> It does not set variables, but it does read the values (which may be
> variables) that define the connection quite early in the test.
>
> > So I must send user/pass in command-line as properties or define in
> JMX,
> > right?
>
> Depends which user/pass you are referring to.
>
> Please clarify exactly what you are trying to do.
>
> > Ori Marko
> > Quality Assurance Engineer
> > Praxell Inc.
> > http://www.praxell.com
> >
> > -----Original Message-----
> > From: sebb [mailto:sebbaz@gmail.com]
> > Sent: Sunday, January 27, 2008 4:49 PM
> > To: JMeter Users List
> > Subject: Re: Dynamic JDBC configuration (user&pass)
> >
> > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > The problem is that I need to get dynamically the user/pass
> > > If it's defined in Test Plan it's not dynamic
> >
> > Not strictly true - you can define variables as property references,
> > and pass in the properties via the command line.
> >
> > > It seems that what was defined in Test Plan can't be override after
> > test
> > > has started
> > > (changing variable value in runtime doesn't change user/pass of JDBC
> > > connection)
> >
> > That's not true - variables defined on the test plan can be changed;
> > however if they are changed after the JDBC Config element has used
> > them, the change will have no effect. That's what happens with the CSV
> > Dataset.
> >
> > > Ori Marko
> > > Quality Assurance Engineer
> > > Praxell Inc.
> > > http://www.praxell.com
> > >
> > > -----Original Message-----
> > > From: sebb [mailto:sebbaz@gmail.com]
> > > Sent: Sunday, January 27, 2008 4:17 PM
> > > To: JMeter Users List
> > > Subject: Re: Dynamic JDBC configuration (user&pass)
> > >
> > > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > > Hi
> > > >
> > > >
> > > >
> > > > How can I use dynamic username and password in JDBC connection
> > > > configuration?
> > >
> > > As normal, just use the variable references.
> > >
> > > > If it's possible can database URL be dynamic?
> > > >
> > >
> > > Have you tried?
> > >
> > > Note that the JDBC config element is processed early on, so CSV
> > > Dataset variables cannot be used, see the note here:
> > >
> > >
> >
> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#CSV
> > > _Data_Set_Config
> > >
> > > I suggest you try replacing the fixed strings with variables defined
> > > on the Test Plan. You can then try other methods of defining the
> > > variables.
> > >
> > > >
> > > > Thanks
> > > >
> > > >
> > > >
> > > > Ori Marko
> > > > Quality Assurance Engineer
> > > > Praxell Inc.
> > > > http://www.praxell.com <http://www.praxell.com>
> > > >
> > > >
> > >
> > >
> ---------------------------------------------------------------------
> > > 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
> >
> >
>
> ---------------------------------------------------------------------
> 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
RE: Dynamic JDBC configuration (user&pass)
Posted by Ori Marco <or...@praxell.com>.
In database connection configuration there are username,password and url
I want to be able to get those parameters from Main DB so I can run
using same JMX tests on several DBs/Configurations.
It seems that this can't be done except sending in command-line.
Ori Marko
Quality Assurance Engineer
Praxell Inc.
http://www.praxell.com
-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com]
Sent: Sunday, January 27, 2008 5:19 PM
To: JMeter Users List
Subject: Re: Dynamic JDBC configuration (user&pass)
On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> Hi
>
> The problem remains, I want to change user/pass variables according to
> values in DB.
Which user / password are you talking about here?
I assume that you need a user and pass to connect to the DB in the
first place ...
> But JDBC Config element is setting its variables at the start of the
> test.
It does not set variables, but it does read the values (which may be
variables) that define the connection quite early in the test.
> So I must send user/pass in command-line as properties or define in
JMX,
> right?
Depends which user/pass you are referring to.
Please clarify exactly what you are trying to do.
> Ori Marko
> Quality Assurance Engineer
> Praxell Inc.
> http://www.praxell.com
>
> -----Original Message-----
> From: sebb [mailto:sebbaz@gmail.com]
> Sent: Sunday, January 27, 2008 4:49 PM
> To: JMeter Users List
> Subject: Re: Dynamic JDBC configuration (user&pass)
>
> On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > The problem is that I need to get dynamically the user/pass
> > If it's defined in Test Plan it's not dynamic
>
> Not strictly true - you can define variables as property references,
> and pass in the properties via the command line.
>
> > It seems that what was defined in Test Plan can't be override after
> test
> > has started
> > (changing variable value in runtime doesn't change user/pass of JDBC
> > connection)
>
> That's not true - variables defined on the test plan can be changed;
> however if they are changed after the JDBC Config element has used
> them, the change will have no effect. That's what happens with the CSV
> Dataset.
>
> > Ori Marko
> > Quality Assurance Engineer
> > Praxell Inc.
> > http://www.praxell.com
> >
> > -----Original Message-----
> > From: sebb [mailto:sebbaz@gmail.com]
> > Sent: Sunday, January 27, 2008 4:17 PM
> > To: JMeter Users List
> > Subject: Re: Dynamic JDBC configuration (user&pass)
> >
> > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > Hi
> > >
> > >
> > >
> > > How can I use dynamic username and password in JDBC connection
> > > configuration?
> >
> > As normal, just use the variable references.
> >
> > > If it's possible can database URL be dynamic?
> > >
> >
> > Have you tried?
> >
> > Note that the JDBC config element is processed early on, so CSV
> > Dataset variables cannot be used, see the note here:
> >
> >
>
http://jakarta.apache.org/jmeter/usermanual/component_reference.html#CSV
> > _Data_Set_Config
> >
> > I suggest you try replacing the fixed strings with variables defined
> > on the Test Plan. You can then try other methods of defining the
> > variables.
> >
> > >
> > > Thanks
> > >
> > >
> > >
> > > Ori Marko
> > > Quality Assurance Engineer
> > > Praxell Inc.
> > > http://www.praxell.com <http://www.praxell.com>
> > >
> > >
> >
> >
---------------------------------------------------------------------
> > 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
>
>
---------------------------------------------------------------------
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
Re: Dynamic JDBC configuration (user&pass)
Posted by sebb <se...@gmail.com>.
On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> Hi
>
> The problem remains, I want to change user/pass variables according to
> values in DB.
Which user / password are you talking about here?
I assume that you need a user and pass to connect to the DB in the
first place ...
> But JDBC Config element is setting its variables at the start of the
> test.
It does not set variables, but it does read the values (which may be
variables) that define the connection quite early in the test.
> So I must send user/pass in command-line as properties or define in JMX,
> right?
Depends which user/pass you are referring to.
Please clarify exactly what you are trying to do.
> Ori Marko
> Quality Assurance Engineer
> Praxell Inc.
> http://www.praxell.com
>
> -----Original Message-----
> From: sebb [mailto:sebbaz@gmail.com]
> Sent: Sunday, January 27, 2008 4:49 PM
> To: JMeter Users List
> Subject: Re: Dynamic JDBC configuration (user&pass)
>
> On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > The problem is that I need to get dynamically the user/pass
> > If it's defined in Test Plan it's not dynamic
>
> Not strictly true - you can define variables as property references,
> and pass in the properties via the command line.
>
> > It seems that what was defined in Test Plan can't be override after
> test
> > has started
> > (changing variable value in runtime doesn't change user/pass of JDBC
> > connection)
>
> That's not true - variables defined on the test plan can be changed;
> however if they are changed after the JDBC Config element has used
> them, the change will have no effect. That's what happens with the CSV
> Dataset.
>
> > Ori Marko
> > Quality Assurance Engineer
> > Praxell Inc.
> > http://www.praxell.com
> >
> > -----Original Message-----
> > From: sebb [mailto:sebbaz@gmail.com]
> > Sent: Sunday, January 27, 2008 4:17 PM
> > To: JMeter Users List
> > Subject: Re: Dynamic JDBC configuration (user&pass)
> >
> > On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > > Hi
> > >
> > >
> > >
> > > How can I use dynamic username and password in JDBC connection
> > > configuration?
> >
> > As normal, just use the variable references.
> >
> > > If it's possible can database URL be dynamic?
> > >
> >
> > Have you tried?
> >
> > Note that the JDBC config element is processed early on, so CSV
> > Dataset variables cannot be used, see the note here:
> >
> >
> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#CSV
> > _Data_Set_Config
> >
> > I suggest you try replacing the fixed strings with variables defined
> > on the Test Plan. You can then try other methods of defining the
> > variables.
> >
> > >
> > > Thanks
> > >
> > >
> > >
> > > Ori Marko
> > > Quality Assurance Engineer
> > > Praxell Inc.
> > > http://www.praxell.com <http://www.praxell.com>
> > >
> > >
> >
> > ---------------------------------------------------------------------
> > 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
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
RE: Dynamic JDBC configuration (user&pass)
Posted by Ori Marco <or...@praxell.com>.
Hi
The problem remains, I want to change user/pass variables according to
values in DB.
But JDBC Config element is setting its variables at the start of the
test.
So I must send user/pass in command-line as properties or define in JMX,
right?
Ori Marko
Quality Assurance Engineer
Praxell Inc.
http://www.praxell.com
-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com]
Sent: Sunday, January 27, 2008 4:49 PM
To: JMeter Users List
Subject: Re: Dynamic JDBC configuration (user&pass)
On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> The problem is that I need to get dynamically the user/pass
> If it's defined in Test Plan it's not dynamic
Not strictly true - you can define variables as property references,
and pass in the properties via the command line.
> It seems that what was defined in Test Plan can't be override after
test
> has started
> (changing variable value in runtime doesn't change user/pass of JDBC
> connection)
That's not true - variables defined on the test plan can be changed;
however if they are changed after the JDBC Config element has used
them, the change will have no effect. That's what happens with the CSV
Dataset.
> Ori Marko
> Quality Assurance Engineer
> Praxell Inc.
> http://www.praxell.com
>
> -----Original Message-----
> From: sebb [mailto:sebbaz@gmail.com]
> Sent: Sunday, January 27, 2008 4:17 PM
> To: JMeter Users List
> Subject: Re: Dynamic JDBC configuration (user&pass)
>
> On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > Hi
> >
> >
> >
> > How can I use dynamic username and password in JDBC connection
> > configuration?
>
> As normal, just use the variable references.
>
> > If it's possible can database URL be dynamic?
> >
>
> Have you tried?
>
> Note that the JDBC config element is processed early on, so CSV
> Dataset variables cannot be used, see the note here:
>
>
http://jakarta.apache.org/jmeter/usermanual/component_reference.html#CSV
> _Data_Set_Config
>
> I suggest you try replacing the fixed strings with variables defined
> on the Test Plan. You can then try other methods of defining the
> variables.
>
> >
> > Thanks
> >
> >
> >
> > Ori Marko
> > Quality Assurance Engineer
> > Praxell Inc.
> > http://www.praxell.com <http://www.praxell.com>
> >
> >
>
> ---------------------------------------------------------------------
> 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
Re: Dynamic JDBC configuration (user&pass)
Posted by sebb <se...@gmail.com>.
On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> The problem is that I need to get dynamically the user/pass
> If it's defined in Test Plan it's not dynamic
Not strictly true - you can define variables as property references,
and pass in the properties via the command line.
> It seems that what was defined in Test Plan can't be override after test
> has started
> (changing variable value in runtime doesn't change user/pass of JDBC
> connection)
That's not true - variables defined on the test plan can be changed;
however if they are changed after the JDBC Config element has used
them, the change will have no effect. That's what happens with the CSV
Dataset.
> Ori Marko
> Quality Assurance Engineer
> Praxell Inc.
> http://www.praxell.com
>
> -----Original Message-----
> From: sebb [mailto:sebbaz@gmail.com]
> Sent: Sunday, January 27, 2008 4:17 PM
> To: JMeter Users List
> Subject: Re: Dynamic JDBC configuration (user&pass)
>
> On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> > Hi
> >
> >
> >
> > How can I use dynamic username and password in JDBC connection
> > configuration?
>
> As normal, just use the variable references.
>
> > If it's possible can database URL be dynamic?
> >
>
> Have you tried?
>
> Note that the JDBC config element is processed early on, so CSV
> Dataset variables cannot be used, see the note here:
>
> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#CSV
> _Data_Set_Config
>
> I suggest you try replacing the fixed strings with variables defined
> on the Test Plan. You can then try other methods of defining the
> variables.
>
> >
> > Thanks
> >
> >
> >
> > Ori Marko
> > Quality Assurance Engineer
> > Praxell Inc.
> > http://www.praxell.com <http://www.praxell.com>
> >
> >
>
> ---------------------------------------------------------------------
> 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
RE: Dynamic JDBC configuration (user&pass)
Posted by Ori Marco <or...@praxell.com>.
The problem is that I need to get dynamically the user/pass
If it's defined in Test Plan it's not dynamic
It seems that what was defined in Test Plan can't be override after test
has started
(changing variable value in runtime doesn't change user/pass of JDBC
connection)
Ori Marko
Quality Assurance Engineer
Praxell Inc.
http://www.praxell.com
-----Original Message-----
From: sebb [mailto:sebbaz@gmail.com]
Sent: Sunday, January 27, 2008 4:17 PM
To: JMeter Users List
Subject: Re: Dynamic JDBC configuration (user&pass)
On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> Hi
>
>
>
> How can I use dynamic username and password in JDBC connection
> configuration?
As normal, just use the variable references.
> If it's possible can database URL be dynamic?
>
Have you tried?
Note that the JDBC config element is processed early on, so CSV
Dataset variables cannot be used, see the note here:
http://jakarta.apache.org/jmeter/usermanual/component_reference.html#CSV
_Data_Set_Config
I suggest you try replacing the fixed strings with variables defined
on the Test Plan. You can then try other methods of defining the
variables.
>
> Thanks
>
>
>
> Ori Marko
> Quality Assurance Engineer
> Praxell Inc.
> http://www.praxell.com <http://www.praxell.com>
>
>
---------------------------------------------------------------------
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
Re: Dynamic JDBC configuration (user&pass)
Posted by sebb <se...@gmail.com>.
On 27/01/2008, Ori Marco <or...@praxell.com> wrote:
> Hi
>
>
>
> How can I use dynamic username and password in JDBC connection
> configuration?
As normal, just use the variable references.
> If it's possible can database URL be dynamic?
>
Have you tried?
Note that the JDBC config element is processed early on, so CSV
Dataset variables cannot be used, see the note here:
http://jakarta.apache.org/jmeter/usermanual/component_reference.html#CSV_Data_Set_Config
I suggest you try replacing the fixed strings with variables defined
on the Test Plan. You can then try other methods of defining the
variables.
>
> Thanks
>
>
>
> Ori Marko
> Quality Assurance Engineer
> Praxell Inc.
> http://www.praxell.com <http://www.praxell.com>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org