Re: data persistence problem with Class::DBI

[prev] [thread] [next] [Date index for 2005/04/14]

Eric W. Bates wrote:
> I'm a list newbie; so I apologize if this question has been hashed
> before and my google queries were simply badly written.
> 
> We're using Class::DBI in a mod_perl context and all is working quite
> well.  However, sometimes a CDBI object persists with old data after the
> record has been updated. Hitting apache with a 'graceful' fixes it.
> 
> We have separate handlers for displaying and editing the records; so I'm
> assuming that the copy of the object used in the display handler is
> persisting between accesses in spite of the handler's code
> reinstantiating the object with a retrieve().

mod_perl doesn't make your objects persistent unless you create some
sort of session and store your objects in it, or you have a problem in
your code (closure, global, etc).

Besides issues with your code, it can also be database related. Are you
using MySQL with InnoDB tables? then it could be your transaction
isolation level.

You might have a look at the wiki page for some more details on using
Class::DBI with mod_perl (sorry it's down at the moment)


> 
> Anybody dealt with this?
> 
> Think it's a feature of Ima::DBI or some other part of Class::DBI?
> 
> Thanks for your time.
> 
> --
> Eric W. Bates
> ericx@xxxxxxxx.xxx

        -- 
        Michael Peters
Developer
Plus Three, LP