[Catalyst] CDBI issue?

[Alan Humphrey]

Many thanks!  The discussion you pointed me to included another
alternative, which is working for me.

	   $site =
BirdWeb::Admin::M::BirdWebDB::BirdingSites->retrieve($parms->{id});
	   eval {
		 $site->update_from_form( $checked );
		 $site->remove_from_object_index();
	   };

The "remove_from_object_index" call does the trick.

- Alan

-----Original Message-----
From: Perrin Harkins [mailto:perrin at elem.com] 
Sent: Wednesday, May 11, 2005 9:56 AM
To: Alan Humphrey
Cc: catalyst at lists.rawmode.org
Subject: Re: [Catalyst] CDBI issue?

On Wed, 2005-05-11 at 10:43 -0700, Alan Humphrey wrote:
> Is there something I need to do to
> clear the object from memory?

If you are using InnoDB tables, set your isolation level to
READ_COMMITTED.  Otherwise, try this in your startup.pl:
$Class::DBI::Weaken_Is_Available = 0;

There is discussion of this on the wiki at http://class-dbi.com/.

- Perrin