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: Resource name=jdbc/oracle auth=Container type=javax.sql.DataSource driverClassName=oracle.jdbc.OracleDriver factory=org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory

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): Resource name=jdbc/oracle auth=Container [...] validationQuery =select 1 from dual testOnBorrow =true testOnReturn =true testWhileIdle =true removeAbandoned=true timeBetweenEvictionRunsMillis =60

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): Resource name=jdbc/oracle auth=Container [...] validationQuery =select 1 from dual testOnBorrow =true testOnReturn

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 Connector address=ip-address port=80 redirectPort=8443 minSpareThreads=25 connectionTimeout=2 maxSpareThreads=75 maxThreads

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.5 db server

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 . ?xml version=1.0 encoding=UTF-8? Server Listener className=org.apache.catalina.mbeans.GlobalResourcesLifecycleListener/

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. ?xml version=1.0 encoding=UTF-8? Server Listener

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

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. We've tried

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