You are right. As far as I understand firebird does not require begin to start a transaction yet web2py should not fire an exception if you try to begin. I am fixing it in trunk. Please take a look and let us know. I have never tested this with firebird.
Massimo On Jun 17, 8:41 pm, Doug Warren <[email protected]> wrote: > I was poking around sql.py tonight and noticed something odd: > distributed_transaction_begin has code for mysql and postgres > distributed_transaction_commit has code for mysql, postgres, and firebird. > > The exception in begin says it only works on postgres though it has > code for both postgres and mysql, the exception in commit says it only > works in firebird and postgres though there is code for all three > databases. Is there supposed to be code in begin for Firebird? > > http://www.web2py.com/AlterEgo/default/show/101also states that > distributed transactions are only available on postgres. > > http://www.mail-archive.com/[email protected]/msg24164.html > seems to be where firebird was added and states that the way to use it > is to call begin, make your updates, then call commit. However, > unless I'm missreading the code, the exception in begin should fire > preventing this from working. > > Am I missing something with the code or has the unit tests for this > not been working since last October? Or did this break sometime > after?
