jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jatin <daveyja...@gmail.com>
Subject Re: JDBC Connection Configuration Queries
Date Sun, 03 Jan 2010 15:42:48 GMT
Hi Deepak

Have a question based on your reply.

2. Validation Query:

You said that the validation query would periodically fire a query to 
the DB. May i know what is the request that is sent as part of the 
query. Is it a query to retrieve any data. If so then what data is being 
retrieved. Can you provide more details on this.

Thanks
Jatin

Deepak Shetty wrote:
> Hi
> 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.
>
> regards
> deepak
>
>
> On Sat, Jan 2, 2010 at 3:51 AM, Jatin <daveyjatin@gmail.com> 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:
>>
>>
>> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#JDBC_Connection_Configuration
>>
>> Thanks
>> Jatin
>>
>> ---------------------------------------------------------------------
>> 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


Mime
View raw message