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 checks
In the section on optimizing the db and prepare statements (in the
http://perl.apache.org/guide/performance.html url), the document discusses
creating a subroutine called "connect" in a package called package My::DB;
My question is if you have the
my $dbh = My::DB-connect;
statement in another
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]
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
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
