On 04/04/2012 12:08, S Ahmed wrote: > My db connections seem to be lost after an extended period of inactivity > (for a web application). And the only way to get the connections to work > again is to restart tomcat. > > My tomcat.jdbc.pool.Datasource settings have: > > <property name="maxActive" value="100"/> > <property name="maxIdle" value="30"/> > <property name="maxWait" value="1000"/> > <property name="defaultAutoCommit" value="true"/> > <property name="removeAbandoned" value="true"/> > <property name="removeAbandonedTimeout" value="60"/> > > > Is it the removedAbonded and abandonedTimeout? Does it mean "after 60 > seconds, remove the connection from the pool? > > I guess what I need is a minActive setting then?
Do you have a connection validation query and test set? E.g. testOnBorrow=true? p -- [key:62590808]
signature.asc
Description: OpenPGP digital signature
