Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 9iAS DAD reuse problem

9iAS DAD reuse problem

From: Chad Paquette <chad.paquette_at_sympatico.ca>
Date: 17 Sep 2002 12:41:35 -0700
Message-ID: <36270158.0209171141.27adf5ae@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US