You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by aidy lewis <ai...@googlemail.com> on 2009/03/12 13:25:15 UTC
JDBC Request and Connection Pools
Hi,
Regarding the JDBC Request, if I have 100 threads to simulate 100
users wouldn't I want connection pooling to be turned off.
In the JDBC Connection Configuration would that mean I set the maximum
number of pool connections to 1?
Aidy
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Request and Connection Pools
Posted by aidy lewis <ai...@googlemail.com>.
Hi Sebb
2009/3/12 sebb <se...@gmail.com>:
> Which is why there is an option to have 1 connection per-thread by
> setting the pool count to 0 (zero).
Thanks. This is what I was exactly looking for.
Aidy
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Request and Connection Pools
Posted by sebb <se...@gmail.com>.
On 12/03/2009, aidy lewis <ai...@googlemail.com> wrote:
> Hi Sebb
>
>
> > Which is why there is an option to have 1 connection per-thread by
> > setting the pool count to 0 (zero).
>
>
> Is it possible to verify whether each thread is creating a seperate connection?
Switch on debugging, or check the database.
> Aidy
>
> ---------------------------------------------------------------------
> 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: JDBC Request and Connection Pools
Posted by aidy lewis <ai...@googlemail.com>.
Hi Sebb
> Which is why there is an option to have 1 connection per-thread by
> setting the pool count to 0 (zero).
Is it possible to verify whether each thread is creating a seperate connection?
Aidy
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Request and Connection Pools
Posted by sebb <se...@gmail.com>.
On 12/03/2009, aidy lewis <ai...@googlemail.com> wrote:
> Hi,
>
> Regarding the JDBC Request, if I have 100 threads to simulate 100
> users wouldn't I want connection pooling to be turned off.
I think you would *always* want it turned off if you are trying to
test a server via JDBC...
I'm not sure what the use case for using pooling is, given that JMeter
threads are intended to represent independent users.
> In the JDBC Connection Configuration would that mean I set the maximum
> number of pool connections to 1?
Which is why there is an option to have 1 connection per-thread by
setting the pool count to 0 (zero).
> Aidy
>
> ---------------------------------------------------------------------
> 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