Forum OpenACS Q&A: Re: how do you get locking transactions to work?

Collapse
4: Re: how do you get locking transactions to work? (response to 2)
Posted by Andrew Piskorski on 06/01/06 10:01 AM
Derick's and Claudio's comments are exactly right, you should never use more than one database handle within a single db_transaction block. Breaking that rule is a problem that periodically pops up here in the forums. A good fix would be to implement this: db_transaction should throw error for multiple database handles.

It's not clear to me that this actually had anything directly to do with Robert's problem, but it's good advice regardless.