Re: mod_perl + Apache 1.3.28

[David Wheeler]

On Thursday, August 14, 2003, at 11:39  AM, David Wheeler wrote:

Caching can be useful in some applications, but it can also cause 
problems and should be used with care. The exact behaviour of this 
method is liable to change, so if you intend to use it in any 
production applications you should discuss your needs on the 
dbi-users mailing list.
So, do I need to ask anyone other than you, Perrin? Tim, are you 
listening? Is this still somewhat experimental?
Switching to connect_cached() seems to have made my problem with Apache 
1.3.28 go away Yay! Oh, and BTW, I am doing cleanup by running my 
entire request in an eval:

sub handler {
    my ($r) = @_;
    # Handle the request.
    my $status;
    eval {
        # Start the database transactions.
        begin(1);
        # Handle the request.
        $status = $ah->handle_request($r);
        # Commit the database transactions.
        commit(1);
    };
    # Do error processing, if necessary.
    return $@ ? handle_err($r, $@) : $status;
}
handle_err() of course does a rollback.

Rudy, I also find that the latest DBD::Pg in CVS compiles and tests 
great on Mac OS X. We ready to package up 1.31_3 for general release on 
CPAN?

I've also fixed the way AutoCommit is set up in Bric::Util::DBI, thanks 
to your notes, Rudy. Hopefully we'll have no more problems!

Now, one more question: when are we going to see support for 
begin_work() in DBD::Pg?

Many TIA to all who gave me feedback with this issue, especially Rudy 
and Perrin.

Regards,

David

--
David Wheeler                                     AIM: dwTheory
[EMAIL PROTECTED]                              ICQ: 15726394
http://www.kineticode.com/                     Yahoo!: dew7e
                                               Jabber: [EMAIL PROTECTED]
Kineticode. Setting knowledge in motion.[sm]