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
- Original Message -
My db connections seem to be lost after an extended period of
inactivity
There could be a number of reasons that this occurs. Perhaps a network issue
is causing them to be disconnected or the database may be timing them out. At
any rate, it's not likely that
timeBetweenEvictionRunsMillis=-1
minEvictableIdleTimeMillis=28800
-Original Message-
From: Daniel Mikusa [mailto:dmik...@vmware.com]
Sent: Wednesday, April 04, 2012 7:46 AM
To: Tomcat Users List
Subject: Re: jdbc pool properties
- Original Message -
My db connections seem to be lost after an extended
L Propes barry.l.pro...@citi.com
To: Tomcat Users List users@tomcat.apache.org
Sent: Wednesday, April 4, 2012 7:53:26 AM
Subject: RE: jdbc pool properties
There are some databases that do go in and periodically kill off
connections, aside from the Tomcat settings.
In addition
Daniel,
Your suggestion seems to have worked so far, thanks!
testOnBorrow=true and validationQuery=SELECT 1
On Wed, Apr 4, 2012 at 8:46 AM, Daniel Mikusa dmik...@vmware.com wrote:
- Original Message -
My db connections seem to be lost after an extended period of
inactivity
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daniel,
On 4/4/12 8:46 AM, Daniel Mikusa wrote:
- Original Message -
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
I'm using tomcat 7, in a spring mvc application. The properties is in my
spring-context.xml file.
bean id=dataSource class=org.apache.tomcat.jdbc.pool.DataSource
destroy-method=close
property name=driverClassName value=com.mysql.jdbc.Driver/
property name=url