Newbie question to mod_perl and Apache::DBI

[Caroline Kliegl <ca...@gmx.de>]

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

Re: Newbie question to mod_perl and Apache::DBI

[Ajit Deshpande <aj...@skycorp.net>]

On Thu, Feb 08, 2001 at 11:57:50PM +0100, Caroline Kliegl wrote:
>[..] 
> 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.
> [..]

You need to compile mod_perl with PERL_STACKED_HANDLERS = 1.

See following for details:
http://perl.apache.org/guide/databases.html#Apache_DBI_does_not_work

Ajit