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 <[email protected]> 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: [email protected] > For additional commands, e-mail: [email protected] > >
