Tim Bunce <[EMAIL PROTECTED]> writes:
> On Mon, Nov 01, 1999 at 09:01:48PM +0000, Tim Bunce wrote:
> > Has anyone experienced a situation where a process (httpd for example)
> > can't reconnect to Oracle after a "shutdown abort"?
>
> Thanks for your replies.
>
> The problem reported to me which prompted this email has actually
> proven to be a user script error. The old database handle was being
> reused, rather than the new one returned from a fresh call to
> DBI->connect after the shutdown and restart.
With a web server you always want to reuse the database handle as long as
possible. That's true of any long-running application though.
How is the application supposed to know it has been disconnected?
Maybe the driver should (maybe optionally) automatically reconnect?
--
greg
