[Dbix-class] connect problem

Sym Kat symkat at symkat.com
Wed Nov 16 18:06:08 GMT 2011


Hi Alan,

Try using:

testproductiondb:****

    dsn: DBI:ODBC:sas****

    user: user****

    password: pass

    LongReadLen: 5000


There was a change to the configuration file to treat the entire config as
a hash, instead of having an options array, to make it a compatible with
other configuration loaders.  This came out between 0.1.0 and 0.1.1.  The
current release is 0.1.6 and I don't foresee any other changes with the API.


I'm sorry for the inconvenience.

On Wed, Nov 16, 2011 at 9:32 AM, Alan Humphrey <alan.humphrey at comcast.net>w=
rote:

> I=92m trying to use DBIx::Class::Schema::Config to manage my db connection
> info.  It was working, but after an upgrade it isn=92t.****
>
> ** **
>
> It looks like something in how the connection information is stored/used
> changed.  Trouble is, I don=92t know who=92s at fault.****
>
> ** **
>
> See below for a program snippet and output showing the change.  The
> problem is with the options portion of the connection info.  It works fine
> for $schema, doesn=92t work for $schema1.****
>
> ** **
>
> Any pointers are appreciated.****
>
> ** **
>
> **-          **Alan****
>
> ** **
>
> DBIx::Class version: 0.08195****
>
> DBIx::Class::Schema::Config  version: 0.001006****
>
> ** **
>
> dbic.yml entry:****
>
> ** **
>
> testproductiondb:****
>
>     dsn: DBI:ODBC:sas****
>
>     user: user****
>
>     password: pass****
>
>     options: ****
>
>         LongReadLen: 5000****
>
> ** **
>
> my $schema =3D BirdWeb::BirdWebSchema->connect('DBI:ODBC:sas', 'user',
> 'pass', {LongReadLen =3D> 5000});****
>
> my $schema1 =3D BirdWeb::BirdWebSchema->connect('testproductiondb');****
>
> ** **
>
> say Dumper($schema->storage->connect_info);****
>
> say Dumper($schema1->storage->connect_info);****
>
> ** **
>
> $VAR1 =3D [****
>
>           {****
>
>             'password' =3D> 'pass',****
>
>             'LongReadLen' =3D> 5000,****
>
>             'dsn' =3D> 'DBI:ODBC:sas',****
>
>             'user' =3D> 'user'****
>
>           }****
>
>         ];****
>
> ** **
>
> $VAR1 =3D [****
>
>           {****
>
>             'password' =3D> 'pass',****
>
>             'options' =3D> {****
>
>                            'LongReadLen' =3D> 5000****
>
>                          },****
>
>             'dsn' =3D> 'DBI:ODBC:sas',****
>
>             'user' =3D> 'user'****
>
>           }****
>
>         ];****
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive:
> http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20111116/2ad=
8fad8/attachment.htm


More information about the DBIx-Class mailing list