Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 9iAS DAD reuse problem
Hi,
We are having a problem when we set reuse to yes in the wdbsvr.app
file. Our app server and database are seperated by a firewall. The
firewall is set to drop inactive connections after 30 seconds (we have
NO control over the settings of the firewall). When DAD reuse is
turned on, a bunch of connections are made to the database and are
pooled to service incoming requests. When this feature is turned on
our web apps were behaving funny. Sometimes they would work and
sometimes they wouldn't. We finally discovered that it was the
firewall that was terminating all the pooled DB connections after 30
seconds. The firewall drops the connections but 9iAS does not know
they are dropped so that when a request is made to run a web app, 9iAS
tries to use a DB connection from the pool which doesn't exist
anymore. To make things work we have disabled the reuse feature. Has
anyone encountered this problem? Found a solution?
Thanks
Chad Paquette Received on Tue Sep 17 2002 - 14:41:35 CDT