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]
