Re: mod_perl/DBI problem

[Curtis Hawthorne]

Even when using Apache::DBI, I still have the same problem - If it times out
once, it won't try again.  I set Apache::DBI::DEBUG = 2, and here's the log:

When I first load the page and get the timeout:

197345 Apache::DBI             need ping: yes
197345 Apache::DBI             new connect to
'DatabaseusernamepasswordPrintError=1RaiseError=1AutoCommit=1'
[Tue Jul 31 09:31:45 2001] [error] DBI->connect(Database) failed:
[Microsoft][ODBC SQL Server Driver]Timeout expired (SQL-S1T00)(DBD:
db_login/SQLConnect err=-1) at DatabaseStuff.pm line 32
Compilation failed in require at (eval 8) line 9.
BEGIN failed--compilation aborted at (eval 8) line 9.

Try to reload the page:
[Tue Jul 31 09:33:11 2001] [error] Can't call method "quote" on an undefined
value at DatabaseStuff.pm line 660.

Try again:
[Tue Jul 31 09:33:14 2001] [error] Can't call method "quote" on an undefined
value at DatabaseStuff.pm line 660.

And so on.  The only thing that seems to fix it is restarting the server,
which by the way is Apache/1.3.20 (Win32) with mod_perl/1.26_01-dev.
Apache::DBI is version 0.87, DBD::ODBC (which I use for my database
connections) is version 0.28.

Any ideas?

Curtis H.

----- Original Message -----
From: "Ged Haywood" <[EMAIL PROTECTED]>
To: "Curtis Hawthorne" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 27, 2001 4:19 PM
Subject: Re: mod_perl/DBI problem


> Hi there,
>
> On Fri, 27 Jul 2001, Curtis Hawthorne wrote:
>
> > So, how can I have it try to connect to the database again if it fails,
but
> > keep the connection persistent if it doesn't?
>
> Have a look in the Guide, there's lots of stuff in there about
> Apache::DBI.  http://perl.apache.org/guide.
>
> 73,
> Ged.
>
>