Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re: "stale data": mysql, ima-dbi, modperl, mason

by rkg (Hermit)
on Dec 26, 2003 at 22:59 UTC ( #317136=note: print w/replies, xml ) Need Help??

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.


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.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://317136]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (7)
As of 2023-06-06 08:50 GMT
Find Nodes?
    Voting Booth?
    How often do you go to conferences?

    Results (26 votes). Check out past polls.