Apache::DBI and caching confusion...

From: Martin Moss (martin_moss_at_btopenworld.com)
Date: 09/13/04 

Date: Mon, 13 Sep 2004 16:30:13 +0100 (BST)
To: dbi-users@perl.org

All,

I'm trying to understand the Apache::DBI mechanism
which caches and returns $dbh handles. My concern is
that Apache DBI uses the connection options, like
AutoCommit=>1 as part of it's caching 'key' mechanism.

Thus would I be right in thinking that if I create a
$dbh with AutoCommit=>1, this gets cached, but then I
later turn AutoCommit off (AutoCommit=>0) that the
database handle given to the next user that comes
along and requests a $dbh with AutoCommit=>1, actually
gets the $dbh, which originally had AutoCommit->1 but
was then turned off - effectively getting an
AutoCommit=>0 handle.

Any light or clarity on this would help immensely,

Kind regards

Marty

        
        
                
___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com