On Monday, July 28, 2003, at 03:39 PM, Johan Schoen wrote:

David Wheeler reported problems with DBI on Apache 1.3.28 and wanted
to know if someone else had problems.
I have no problems with DBI 1.37, DBD::ODBC 1.06 (with minor changes to
Makefile.PL to make it compile) and SAP DB 7.4.3.25 on Apache 1.3.28 on
Redhat 7.3 with Perl 5.8.0, mod_perl 1.28 and mod_ssl 2.8.15.
David, do I need to do something special to get some errors or do all
your connects fail? All I do in my script today is connecting, selecting
one column from a table, inserting a new record into the same table with two
columns and then disconnecting (or not because I use Apache::DBI).

Well, it typically succeeds the first time for me, but then attempts to the the database for other queries on subsequent requests fail. I think that somehow Apache 1.3.28 + mod_perl is dropping the connection to the database after the first or second request, but DBI doesn't know it (it's not calling disconnect()).


Once or twice I managed to restart the server and then not have the problem for several hours, but it always came back eventually.

Thanks for checking it out, Johan.

Regards,

David

--
David Wheeler                                     AIM: dwTheory
[EMAIL PROTECTED]                              ICQ: 15726394
http://kineticode.com/                         Yahoo!: dew7e
                                               Jabber: [EMAIL PROTECTED]
Kineticode. Setting knowledge in motion.[sm]



Reply via email to