-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
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
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