connect_cached resets %attr to defaults?

Does connect_cached() reset attributes each time it's called? Even if
just returning an active $dbh?


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.

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


--
Bill Moseley
moseley@hank.org

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.