RE: Db connection issue due to firewall

2009-08-31 Thread Caldarale, Charles R
> From: chandra ganta [mailto:chandrasekhar...@gmail.com] > Subject: Re: Db connection issue due to firewall > > address="ip-address" > port="80" > redirectPort="8443" > minSpareThreads="25" >

Re: Db connection issue due to firewall

2009-08-31 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael, On 8/31/2009 3:47 PM, Michael Ludwig wrote: > Christopher Schultz schrieb am 31.08.2009 um 11:21:32 (-0400): > >>> >> [...] >>> validationQuery ="select 1 from dual" >>> testOnBorrow ="true" >>> testOnReturn ="true" >>> testWhile

Re: Db connection issue due to firewall

2009-08-31 Thread Michael Ludwig
Christopher Schultz schrieb am 31.08.2009 um 11:21:32 (-0400): > >> [...] > > validationQuery ="select 1 from dual" > > testOnBorrow ="true" > > testOnReturn ="true" > > testWhileIdle ="true" > > removeAbandoned="true" > > timeBetweenEvictionRunsMillis ="60" > > numTestsPer

Re: Db connection issue due to firewall

2009-08-31 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chandra, On 8/27/2009 7:50 AM, chandra ganta wrote: > type="javax.sql.DataSource" > driverClassName="oracle.jdbc.OracleDriver" > factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" > url="jdbc:oracle:thin:@ip-add

Re: Db connection issue due to firewall

2009-08-27 Thread chandra ganta
Hi Chris , We are using Tomcat 5.5 and Java 1.5 ,the below is the configuration of server.xml , I am getting the exception when server is ideal from some amout of time (app 2- 3 ) hours.

Re: Db connection issue due to firewall

2009-08-27 Thread chandra ganta
Hi Mark , This is server.xml configuration ,we are configuring mutiple hosts in server.xml , i setted the attribute testOnBorrow ="true" ., but it is still not working .

Re: Db connection issue due to firewall

2009-08-27 Thread Mark Thomas
Christopher Schultz wrote: > Mark, > > On 8/26/2009 2:44 PM, Mark Thomas wrote: >> Christopher Schultz wrote: >>> Chandra, >>> >>> On 8/25/2009 11:56 PM, chandra ganta wrote: We use a db datasource for one of our applications. The issue is that there is a firewall between tomcat server 5

Re: Db connection issue due to firewall

2009-08-26 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark, On 8/26/2009 2:44 PM, Mark Thomas wrote: > Christopher Schultz wrote: >> Chandra, >> >> On 8/25/2009 11:56 PM, chandra ganta wrote: >>> We use a db datasource for one of our applications. >>> The issue is that there is a firewall between tomcat

Re: Db connection issue due to firewall

2009-08-26 Thread Mark Thomas
Christopher Schultz wrote: > Chandra, > > On 8/25/2009 11:56 PM, chandra ganta wrote: >> We use a db datasource for one of our applications. >> The issue is that there is a firewall between tomcat server 5.5 & db server >> (ORACLE 9i), that cuts pool connections after 1 hour of ideal time. > >> W

Re: Db connection issue due to firewall

2009-08-26 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chandra, On 8/25/2009 11:56 PM, chandra ganta wrote: > We use a db datasource for one of our applications. > The issue is that there is a firewall between tomcat server 5.5 & db server > (ORACLE 9i), that cuts pool connections after 1 hour of ideal ti

RE: Db connection issue due to firewall

2009-08-26 Thread Jeffrey Janner
: chandra ganta [mailto:chandrasekhar...@gmail.com] Sent: Tuesday, August 25, 2009 10:56 PM To: users@tomcat.apache.org Subject: Db connection issue due to firewall Hello, We use a db datasource for one of our applications. The issue is that there is a firewall between tomcat server 5.5 & db se

Db connection issue due to firewall

2009-08-25 Thread chandra ganta
Hello, We use a db datasource for one of our applications. The issue is that there is a firewall between tomcat server 5.5 & db server (ORACLE 9i), that cuts pool connections after 1 hour of ideal time. We've tried several configuration using : validationQuery testOnBorrow testOnReturn testWhil