[Catalyst] Issues with Session::Store::DBIC + MSSQL

[fREW Schmidt]

On Tue, Aug 4, 2009 at 4:12 PM, Daniel Westermann-Clark <dwc at pobox.com>wrot=
e:

> On 2009-08-04 10:20:22 -0500, fREW Schmidt wrote:
> > I am trying to set up Session::Store::DBIC but I am getting no love.
> > Here is all of the relevant (afaik) data:
> >
> > Error:
> >
> > [Tue Aug 4 09:54:25 2009] acd_server.pl:
> > > DBIx::Class::ResultSet::find_or_create(): DBI Exception: DBD::ODBC::st
> > > fetchrow_array failed: [Microsoft][SQL Native Client]String data, rig=
ht
> > > truncation (SQL-01004) [for Statement "SELECT me.id, me.session_data,
> > > me.expires FROM Session me WHERE ( me.id =3D ? )" with ParamValues:
> > > 1=3D'session:c28d6383a2b334128738f4b70ee08ff7df5cd737'] at
> > >
> c:/strawberry/perl/site/lib/Catalyst/Plugin/Session/Store/DBIC/Delegate.pm
> > > line 73
>
> That session ID is 48 characters long, but your table was created with
> a column length of 72 characters (as recommended in the docs).
>
> Could you try creating the table using a VARCHAR instead of CHAR?
> Perhaps MSSQL is being strict about the length of the input string.
>
> If this turns out to be the case, think you could throw together a doc
> patch?
>
> > SQL Creation Script
> >
> > CREATE TABLE dbo.Session
> > > (
> > > id char(72) NOT NULL,
> > > session_data text,
> > > expires int
> > > ) ON [PRIMARY]
> > > TEXTIMAGE_ON [PRIMARY]
> > > GO
>
>
Unfortunately I'm getting the same error.  Any other ideas?
-- =

fREW Schmidt
http://blog.afoolishmanifesto.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20090805/963bc=
ee8/attachment.htm