Re: CDBI and mod_perl

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

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

Rod McChesney <rod.mcchesney@xxxxx.xxx> wrote:
> This is a new but related issue: combining do_transaction
> (http://www.class-dbi.com/cgi-bin/wiki/index.cgi?AtomicUpdates) with the
> db_Main override doesn't work if you are running with AutoCommit off.

You mean "on," right? If AutoCommit is already off in your connection
attributes, then the "local $class->db_Main->{AutoCommit}" is superfluous, I
believe. Indeed, I use do_transaction() all the time with AutoCommit off in
my connection attributes and I have that "local" line commented out since,
until a week ago, I was running on Perl 5.6.1 and didn't want to leak memory
with each transaction.

> BTW, for mod_perl, does it not work correctly to just use DBI::connect
> instead of Perrin's code that caches the handle in pnotes? I'm not a
> mod_perl expert so I'm likely missing something, but it seems from the
> docs that connect() is redefined by Apache to do the right thing.

You mean Apache::DBI? Yes, I think so. That's a very good point actually. I
think Perrin gave up on Apache::DBI entirely and has basically implemented
his own connection caching system using pnotes and has installed his own
clean up handler to do automatic rollbacks. Is that right, Perrin? The result
is the same, but, if you want to continue to use Apache::DBI, then you just
need to avoid the mod_perl dbh closure problem in Ima::DBI and have a db_Main
that always invokes DBI->connect or DBI->connect_cached (since both methods
utilize Apache::DBI in recent versions of DBI).

(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