tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeffrey Janner" <Jeffrey.Jan...@PolyDyne.com>
Subject RE: Db connection issue due to firewall
Date Wed, 26 Aug 2009 13:53:18 GMT
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: chandra ganta [mailto:chandrasekhargvv@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
server
(ORACLE 9i), that cuts pool connections after 1 hour of  ideal time.


We've tried several configuration using :
validationQuery
testOnBorrow
testOnReturn
testWhileIdle
timeBetweenEvictionRunsMillis
numTestsPerEvictionRun
minEvictableIdleTimeMillis

But that does not solve the problem

Could you please give me some advices about the way I have to configure
this
to get it working ?

Best Regards,
Chandra

*******************************  NOTICE  *********************************
This message is intended for the use of the individual or entity to which 
it is addressed and may contain information that is privileged, 
confidential, and exempt from disclosure under applicable law.  If the 
reader of this message is not the intended recipient or the employee or 
agent responsible for delivering this message to the intended recipient, 
you are hereby notified that any dissemination, distribution, or copying 
of this communication is strictly prohibited.  If you have received this 
communication in error, please notify us immediately by reply or by 
telephone (call us collect at 512-343-9100) and immediately delete this 
message and all its attachments.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message