On Thu, 31 Aug 2000, Aaron Johnson wrote:
> I don't work on Oracle so I will speak from my experience with MySQL. MySQL
> servers time out after the 8 hour standard disconnect for inactivity (this
> can be adjusted in your my.conf file). To compensate for this we now run our
> own connect check
I don't work on Oracle so I will speak from my experience with MySQL. MySQL
servers time out after the 8 hour standard disconnect for inactivity (this
can be adjusted in your my.conf file). To compensate for this we now run our
own connect checks for a valid dbh handle before it goes it all the
On Thu, 31 Aug 2000 [EMAIL PROTECTED] wrote:
> What I think is going on is that the script gets killed by Oracle for
> being idle and tries to ping the connection, but the ping fails.
It is supposed to reconnect when the ping fails. I've had problems
getting reconnects to Oracle 8 working. The
>Hmmm. How busy is the site or is still in testing phase?
Testing phase.
>Are you saying your connection is getting dropped and then you get an
error,or that you get dropped and then it has to reconnect?
Here's a sample of errors that I'm getting the error_log file:
[Tue Aug 29 20:15:52 2000