Seems that turning reuse off is your only option given the firewall
behavior. This will add overhead for establishing new connection
for every new request, but you simply can't reuse existing connections
provided that firewall terminates them (ungracefully, which is bad
thing alone) for you and you can't change this behavior...
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Chad Paquette" <chad.paquette_at_sympatico.ca> wrote in message
news:36270158.0209171141.27adf5ae_at_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 Wed Sep 18 2002 - 12:05:18 CDT
