http://qs1969.pair.com?node_id=317136


in reply to "stale data": mysql, ima-dbi, modperl, mason

Well, I found it.

I am not sure why, but somewhere in the bowels of Ima::DBI a transaction was being held, I think.

If I start my <%init> section with

my $dbh = $stash->db_RKG; $dbh->commit;
then all is well.

I am not sure why Ima::DBI was holding a transaction open ......

Thanks. I am relieved. How odd.

rkg

PS For those who might say, "Serves him right, for using an esoteric module like Ima::DBI", well, I opted to use Ima::DBI as Class::DBI is built on it, and I am a big fan of Class::DBI, and because I wanted to keep all my sql in one place, outside of my code.

Perhaps I'll drop Tony Boden, the Ima::DBI maintainer, a note and see if he can explain this all to me....

Replies are listed 'Best First'.
Re: Re: "stale data": mysql, ima-dbi, modperl, mason
by perrin (Chancellor) on Dec 27, 2003 at 16:01 UTC
    If the commit is actually what fixes it, then it has nothing to do with Ima::DBI. You would have the same issue with straight DBI calls.