[Catalyst] update_or_create problem with Catalyst::Engine::Apache::MP13 and DBIC

[Tony Lincoln]

Matt,

I appreciate the response.  The app is mounting the same perl5 tree from
an NFS-mounted filesystem, so I'm pretty sure that all the module
versions are the same.  And Apache::DBI isn't loaded.  The only
difference I can see is that the standalone server doesn't seem to use
DBIx::Class::Storage.  I'll give the other list a try.

Thanks,

Tony

----- Original Message -----
From: Matt S Trout <dbix-class at trout.me.uk>
Date: Thursday, May 25, 2006 4:35 pm
Subject: Re: [Catalyst] update_or_create problem with
Catalyst::Engine::Apache::MP13 and DBIC

> Anthony Lincoln wrote:
> > Okay, I've been building a little app using Catalyst, and I like 
> it a 
> > lot.  However, when it came time to deploy said app on my Apache 
> 1.3.33 
> > server running mod_perl 1.29, all sorts of things don't work the 
> same at 
> > the database layer.
> > 
> > Apparently the MP engine uses 
> DBIx::Class::Storage::DBI::Oracle.pm while 
> > the standalone server does not.  I had to muck around in there 
> because 
> > schema tablenames (schema_name.tablename) seem to be treated 
> differently 
> > than most other modules at this layer.  Once I instructed them to 
> strip 
> > out the schema_name, my data model objects came back.  And there 
> were 
> > some differences in how my TT templates got parsed.  Also, and 
> this is 
> > maddening, update_or_create always wants to create, and never 
> update, 
> > even when I specify something like:
> 
> Erm. Have you checked you've got the same versions of modules 
> loaded in 
> both environments?
> 
> If you're connecting to Oracle an 06000+ DBIx::Class should always 
> end 
> up using the ::Oracle storage class. Plus if mod_perl has 
> Apache::DBI 
> loaded all sorts of weird things may happen (I've been promised 
> tests 
> for this by somebody who was able to reproduce but they haven't 
> turned 
> up quite yet).
> 
> If fixing up the versions doesn't help might I recommend joining 
> the 
> dbix-class@ list and asking on there? I doubt the database problems 
> you're seeing are directly Catalyst-related.
> 
> _______________________________________________
> Catalyst mailing list
> Catalyst at lists.rawmode.org
> http://lists.rawmode.org/mailman/listinfo/catalyst
>