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

[Matt S Trout]

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.