Re: connect_cached resets %attr to defaults?

On Tue, May 22, 2007 at 07:04:27PM -0700, Bill Moseley wrote:
Does connect_cached() reset attributes each time it's called? Even if
just returning an active $dbh?

Yes. You're asking for a handle with specific attributes set, so that's
what it gives you.

On a CDBI application I need to access multiple databases with the
same schema. So my initial attempt was:

sub db_Main {
my $self = shift;
my $connection = $database_registry{$current_database};
my %attr = (
$self->_default_attributes,
%{ $connection->{attr} },
AutoCommit => 1,
pg_enable_utf8 => 1,
private_pid => $$,
);
return DBI->connect_cached( @{$connection}{qw/ dsn user pass /}, \%attr );
}

If I localize AutoCommit (for a transaction) I see this:
T <- STORE('AutoCommit' undef)= 1 at test_model.pl line 27
but next time db_Main is called I see:
T <- STORE('AutoCommit' 1)= 1 at DBI.pm line 672

Which looks like attributes are reset when connect_cached is called.

Yeap. They're set to the values you're asking for.

I guess that's why Ima::DBI doesn't call connect_cached() unless ping fails.

Possibly. May also just have been an optimization.

Tim.
.