Re: CDBI and mod_perl

[prev] [thread] [next] [Date index for 2005/02/10]

From: Drew Wilson
Subject: Re: CDBI and mod_perl
Date: 21:54 on 10 Feb 2005

FWIW, we use Class::DBI and Apache::DBI under mod_perl connecting to 
Postgresql and we haven't had any issues.

The db connection is established lazily, which means they get 
established in the child processes.

We do pre-load DBI and Apache::DBI (in our startup.pl script) without 
importing symbols, as is suggested in the mod_perl performance guide. 
e.g.
     use Apache::DBI ();
     use DBI ();

Drew


On Feb 10, 2005, at 1:37 PM, Perrin Harkins wrote:

> On Thu, 2005-02-10 at 12:58 -0800, Rod McChesney wrote:
>>> I'm new to CDBI, and so far it seems very straightfoward to use. But
>>> it will be used in a mod_perl setting, and after much googling and
>>> Wiki'ing it appears that Ima::DBI and mod_perl still do not play 
>>> nice,
>>> requiring an override of db_Main and mucking about in Ima::DBI's
>>> internals to get everything to work, e.g.,
>>> __PACKAGE__->_remember_handle('Main');
>>>  and so on.
>>>
>>> Am I missing something, or is this correct?
>
> That is partly correct.  If you use transactions, you should override
> db_Main so that Apache::DBI will work.  If you use one of the
> setup_table methods in classes like Class::DBI::Pg, and you preload
> those modules during mod_perl startup, you will need to disconnect the
> DBI connections before mod_perl forks.
>
> However, I don't know of any reason you would need to touch Ima::DBI
> internals or call _remember_handle().
>
> - Perrin
>

(message missing)

Column Names
Justin Tocci 05:19 on 10 Feb 2005

Re: Column Names
Peter Speltz 20:36 on 10 Feb 2005

Re: Column Names
Rod McChesney 20:56 on 10 Feb 2005

CDBI and mod_perl
Rod McChesney 20:58 on 10 Feb 2005

Re: CDBI and mod_perl
Perrin Harkins 21:37 on 10 Feb 2005

Re: CDBI and mod_perl
Drew Wilson 21:54 on 10 Feb 2005

Re: CDBI and mod_perl
karjala_lists 13:59 on 15 Feb 2005

Re: CDBI and mod_perl
Perrin Harkins 22:16 on 10 Feb 2005

Re: CDBI and mod_perl
Drew Wilson 22:27 on 10 Feb 2005

Re: CDBI and mod_perl
Perrin Harkins 22:46 on 10 Feb 2005

Re: CDBI and mod_perl
Edward J. Sabol 23:42 on 10 Feb 2005

Re: CDBI and mod_perl
Rod McChesney 01:55 on 12 Feb 2005

Re: CDBI and mod_perl
Edward J. Sabol 19:43 on 12 Feb 2005

Re: CDBI and mod_perl
Rod McChesney 18:48 on 14 Feb 2005

Re: CDBI and mod_perl
Perrin Harkins 21:23 on 14 Feb 2005

Re: CDBI and mod_perl
Edward J. Sabol 06:53 on 14 Feb 2005

Re: CDBI and mod_perl
Perrin Harkins 21:14 on 14 Feb 2005

Re: CDBI and mod_perl
Perrin Harkins 19:59 on 15 Feb 2005

Re: CDBI and mod_perl
Tim Bunce 22:33 on 15 Feb 2005

Re: CDBI and mod_perl
Tony Bowden 22:12 on 18 Feb 2005

Re: CDBI and mod_perl
=?ISO-8859-1?Q?Ask_Bj=F8rn_Hansen?= 22:19 on 18 Feb 2005

Re: CDBI and mod_perl
Perrin Harkins 22:36 on 18 Feb 2005

Re: CDBI and mod_perl
Tony Bowden 11:23 on 19 Feb 2005

Re: CDBI and mod_perl
Perrin Harkins 13:56 on 19 Feb 2005

Re: CDBI and mod_perl
Tony Bowden 15:57 on 19 Feb 2005

Re: CDBI and mod_perl
Perrin Harkins 16:21 on 19 Feb 2005

Re: CDBI and mod_perl
Perrin Harkins 16:24 on 19 Feb 2005

Re: CDBI and mod_perl
Tony Bowden 09:54 on 20 Feb 2005

Re: CDBI and mod_perl
Perrin Harkins 21:31 on 20 Feb 2005

Re: CDBI and mod_perl
Tony Bowden 22:19 on 20 Feb 2005