jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Deepak Shetty <>
Subject Re: JDBC Connection Configuration Queries
Date Sat, 02 Jan 2010 19:56:16 GMT
2. Validation query - This is normally used in pooling systems to check if
the connection maintained in the pool is still valid. Say you have a pool of
5 connections and the database is restarted , the connections would not be
valid anymore. The Pool implementation could periodically fire a query (the
validation query), which would fail, and these connections would now be
discarded and the pool repopulated with connections.
As to max connection age Im not sure, if i had to guess then it this
parameter would be used to shrink the pool. Say your pool has increased to
10 connections, after which no one has requested a connection for a pool for
say 900 seconds (the max age). After this period the pool implementation
would discard the connection from the pool.


On Sat, Jan 2, 2010 at 3:51 AM, Jatin <> wrote:

> Hi all
> After reading the JMeter user manual on the JDBC connection configuration
> element i found that some of them are not explained there , Hence thought of
> googling them. I still could understand the functionality of the following
> parameters:
> 1. Max Connection Age (ms)
> 2. Validation Query  -- In the manual it is added Select 1 by default , can
> some one explain this in detail.
> Here is the user manual link:
> Thanks
> Jatin
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message