Re: Class::DBI modules not properly loaded under mod_perl ?

[prev] [thread] [next] [Date index for 2004/10/28]

From: Edward J. Sabol
Subject: Re: Class::DBI modules not properly loaded under mod_perl ?
Date: 20:30 on 28 Oct 2004
Perrin Harkins wrote:
> Yes, and that should be enough for a non-transactional database.
> However, if you use Postgres or MySQL with InnoDB tables, you need
> the cleanup handler that Apache::DBI adds to each request, and
> Ima::DBI (used by Class::DBI) will prevent that from happening.

For what it's worth, I'm using Sybase with AutoCommit turned off in a
mod_perl/Apache::DBI/Class::DBI/Mason environment, and I haven't had a
problem. Note that I don't access the database pre-fork. (None of my CDBI
classes use set_up_table().) Anyway, if the cleanup handler isn't working,
then I guess I've just been lucky? Or maybe since I always use my
do_transaction() method when issuing any changes to the database, that's why
I haven't any problems?

> I have an explanation of it, with code to work around it here:
> http://marc.theaimsgroup.com/?l=apache-modperl&m=109882196005065&w=2
>
> Hmm, now that I think about this more, I wonder if changing Ima::DBI
> is the best way to handle this. It already uses connect_cached, so
> the only thing we really need to add is the cleanup handler. Maybe
> that should be split out into a separate module.

Well, I hope some kind of solution is released for mod_perl people.

(message missing)

pager
David R. Baird 09:48 on 20 Oct 2004

Re: pager
David R. Baird 13:53 on 20 Oct 2004

Re: pager
David R. Baird 21:00 on 20 Oct 2004

Re: pager
merlyn (Randal L. Schwartz) 02:55 on 21 Oct 2004

Re: pager
David R. Baird 10:46 on 21 Oct 2004

Re: pager
David R. Baird 11:30 on 21 Oct 2004

Re: pager
merlyn (Randal L. Schwartz) 12:10 on 21 Oct 2004

Re: pager
David R. Baird 23:08 on 21 Oct 2004

Re: pager
Cees Hek 00:22 on 22 Oct 2004

Re: pager
Tony Bowden 08:34 on 22 Oct 2004

Re: pager
Emanuele Zeppieri 13:51 on 22 Oct 2004

Re: pager
David R. Baird 14:41 on 22 Oct 2004

Re: pager
David R. Baird 09:20 on 22 Oct 2004

Class::DBI modules not properly loaded under mod_perl ?
Michele Valzelli 10:55 on 22 Oct 2004

Re: pager
Emanuele Zeppieri 12:21 on 22 Oct 2004

Re: pager
David R. Baird 12:52 on 22 Oct 2004

Re: pager
Emanuele Zeppieri 15:33 on 22 Oct 2004

Re: pager
David R. Baird 16:09 on 22 Oct 2004

Re: pager
David R. Baird 23:30 on 07 Nov 2004

RE: pager
Emanuele Zeppieri 03:50 on 14 Nov 2004

Re: pager
Emanuele Zeppieri 13:25 on 22 Oct 2004

Re: Class::DBI modules not properly loaded under mod_perl ?
Edward J. Sabol 20:30 on 28 Oct 2004

Generated at 11:35 on 01 Dec 2004 by mariachi v0.52