You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Laurent MEDIONI <LM...@sqli.com> on 2003/08/19 18:05:08 UTC
JDBC connection pool
Hi,
does someone know what the connection pool for JDBC sampler exactly means ?
Is the pool available to all Loops of all Threads ? Only for this Sampler ?
And why are the 2 param "Number of Connections in Pool" and "Max Usage For
Each Connection" mandatory at the Sampler level ? What about using a JDBC
Database Connection Pool Defaults then, if everything has to be fixed at the
Sampler level ?
Thanks a lot
Laurent
Re: JDBC connection pool
Posted by Jeremy Arnold <je...@bigfoot.com>.
Hello,
My experience with the JDBC sampler is rather limited, but I've been
looking at the connection pool code recently, so I can take a stab at
answering your questions. Anybody else can feel free to jump in and
claim I'm wrong. :)
From the code, it appears that there is really just one connection
pool per database URL. So if you have multiple JDBC samplers with the
same database URL, they will share a connection pool. I realize that
this probably isn't what you would expect from looking at the GUI.
I can't comment on the JDBC Database Connection Pool
Defaults...haven't looked at that.
I've been doing some work recently on rewriting the connection
pool. If you have some thoughts about how you would like it to work,
please feel free to send them along. This work is planned for the next
major version of JMeter, but we could consider putting it in a 1.9.x
release if there is demand.
Jeremy
http://xirr.com/~jeremy_a
Laurent MEDIONI wrote:
>Hi,
>does someone know what the connection pool for JDBC sampler exactly means ?
>Is the pool available to all Loops of all Threads ? Only for this Sampler ?
>
>And why are the 2 param "Number of Connections in Pool" and "Max Usage For
>Each Connection" mandatory at the Sampler level ? What about using a JDBC
>Database Connection Pool Defaults then, if everything has to be fixed at the
>Sampler level ?
>
>Thanks a lot
>Laurent
>
>---------------------------------------------------------------------
>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 connection pool
Posted by Jeremy Arnold <je...@bigfoot.com>.
Hello,
My experience with the JDBC sampler is rather limited, but I've been
looking at the connection pool code recently, so I can take a stab at
answering your questions. Anybody else can feel free to jump in and
claim I'm wrong. :)
From the code, it appears that there is really just one connection
pool per database URL. So if you have multiple JDBC samplers with the
same database URL, they will share a connection pool. I realize that
this probably isn't what you would expect from looking at the GUI.
I can't comment on the JDBC Database Connection Pool
Defaults...haven't looked at that.
I've been doing some work recently on rewriting the connection
pool. If you have some thoughts about how you would like it to work,
please feel free to send them along. This work is planned for the next
major version of JMeter, but we could consider putting it in a 1.9.x
release if there is demand.
Jeremy
http://xirr.com/~jeremy_a
Laurent MEDIONI wrote:
>Hi,
>does someone know what the connection pool for JDBC sampler exactly means ?
>Is the pool available to all Loops of all Threads ? Only for this Sampler ?
>
>And why are the 2 param "Number of Connections in Pool" and "Max Usage For
>Each Connection" mandatory at the Sampler level ? What about using a JDBC
>Database Connection Pool Defaults then, if everything has to be fixed at the
>Sampler level ?
>
>Thanks a lot
>Laurent
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
>