Re: jdbc pool properties

2012-04-06 Thread S Ahmed
I'm using tomcat 7, in a spring mvc application. The properties is in my spring-context.xml file. On Fri, Apr 6, 2012 at 2:09 PM, Christopher Schultz < ch...@christopherschultz.n

Re: jdbc pool properties

2012-04-06 Thread Christopher Schultz
-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 res

Re: jdbc pool properties

2012-04-05 Thread S Ahmed
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 wrote: > > > - Original Message - > > My db connections seem to be lost after an extended period of > > inactivity > > There cou

Re: jdbc pool properties

2012-04-04 Thread Filip Hanik Mailing Lists
> From: "Barry L Propes" > To: "Tomcat Users List" > 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. > > I

RE: jdbc pool properties

2012-04-04 Thread Propes, Barry L
"true" 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 d

Re: jdbc pool properties

2012-04-04 Thread Daniel Mikusa
- 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

Re: jdbc pool properties

2012-04-04 Thread Pid
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: > > > > >