Oracle Web Application Server 3.0 - recycling connections?

From: Miro Sarbaev <miromail_at_ix.netcom.com>
Date: Mon, 9 Aug 1999 02:22:24 -0700
Message-ID: <37ae9cf3$0$210@nntp1.ba.best.com>

All of the below is based on Oracle Web Application Server 3.0.

If you go to cartridge configuration, it would let you choose minimum and maximum number of instances.
In case of PL/SQL cartridge maximum number of instances will also limit the number of simultaneous database connections which the OWAS will make to the database for multiple web requests. If there would be more requests, they wait.

However, as soon as the request is served by the database, connection (database connection) is closed.
Next incoming request has to establish a new connection. This does not depend on the "Minimum # of Instances" parameter.

Question: does anyone know if it is possible to make database connections 'persistent'? In other words, to have a pool of connections which is always opened, so that the application can save some time on establishing a new connection?

This is something quite common for servers other than OWAS - but I could not find any references on that anywhere in the OWAS documentation. Maybe OWAS 4 has this option?

Please help...
Miro. Received on Mon Aug 09 1999 - 04:22:24 CDT