yup, it's a bug...
#!/usr/bin/perl
use Apache::MyConfig;
my $r = shift;
$r->send_http_header('text/plain');
print "can push_handlers\n" if Apache->can('push_handlers');
print "but PERL_STACKED_HANDLERS: ",
$Apache::MyConfig::Setup{PERL_STACKED_HANDLERS};
basically Apache->can('push_handlers') returns true even if
PERL_STACKED_HANDLERS=0 at build time...
I guess that at some point this worked correctly, otherwise Edmund wouldn't
have coded it that way?
--Geoff
-----Original Message-----
From: Geoffrey Young
To: 'Caroline Kliegl '
Cc: '[EMAIL PROTECTED]'
Sent: 2/8/01 7:52 PM
Subject: RE: Newbie question to mod_perl and Apache::DBI
Apache::DBI will call push_handlers on to issue a rollback if
AutoCommit=0
in your connect string...
but the problem may not be with you... looks like a bug (somewhere):
if(!$Rollback{$Idx} and $needCleanup and Apache->can('push_handlers'){
...
}
looks like calling Apache->can('push_handlers') is returning true even
though you didn't activate PERL_STACKED_HANDLERS. I wonder if somehow
can()
isn't correctly capturing the build-time arguments (something to look
into...)
at any rate, the quickest way to fix this is to rebuild mod_perl with
EVERYTHING=1 or PERL_STACKED_HANDLERS=1 (or don't set AutoCommit=0 in
your
connect string if you can't rebuild it now...)
try these and see if they make a difference...
HTH
--Geoff
-----Original Message-----
From: Caroline Kliegl
To: [EMAIL PROTECTED]
Sent: 2/8/01 5:57 PM
Subject: Newbie question to mod_perl and Apache::DBI
Hi there,
I am new to mod_perl and currently trying to make use of Apache::DBI.
This is my enviroment:
Suse Linux 6.3, Apache 1.3.12, mod_perl 1.24 and Oracle 8i. I am using
HTML:Mason as well, as a templating system. Everything works.
Apache::DBI is loaded via httpd.conf by Apache properly and I can make
use
of it in my scripts, when reading data.
With my other script, updating data, I get the following error :
Rebuild with -DPERL_STACKED_HANDLERS to $r->push_handlers at
/usr/local/lib/perl5/site_perl/5.6.0/Apache/DBI.pm line 93.
and the script does not get to connect the database and dies with a
timeout.
I think, I should add, that in both scripts, the one who is reading and
the
one who is updating, I open and close a $dbh (connect / disconnect).
Anybody having an idea, what I am doing wrong ? Or where to find help ?
Thanks for the help.
Caro
--
------------------
Caroline Kliegl
Neustadt - Germany
Sent through GMX FreeMail - http://www.gmx.net
