> From: chandra ganta [mailto:chandrasekhar...@gmail.com]
> Subject: Re: Db connection issue due to firewall
>
> address="ip-address"
> port="80"
> redirectPort="8443"
> minSpareThreads="25"
>
-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
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
-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
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.
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 .
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
-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
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
-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
Chandra -
The question is better suited for an Oracle group.
However, I happen to know the solution - since I do it all here.
On your Oracle server, add the following line your sqlnet.ora file:
SQLNET.EXPIRE_TIME= 10
Then restart your oracle databases.
Jeff
-Original Message-
From: chand
11 matches
Mail list logo
