werner [2011-07-13 12:50] :

> I did a bit of testing using my own application and so far found one
> place where I run into the following exception if I change
> "sa/dialect/firebird/base.py" to use "False" for "do_commit" and
> "do_rollback".
>

yes that's strange, I don't understand why
you can have the same problem running
sqla_nose.py --db=firebird engine -v

======================================================================
ERROR: test.engine.test_ddlevents.DDLExecutionTest.test_platform_escape
----------------------------------------------------------------------
Traceback (most recent call last):
File
"/home/philippe/dev/python-environments/sqlaP27/lib/python2.7/site-packages/nose-1.0.0-py2.7.egg/nose/case.py",
line 187, in runTest
self.test(*self.arg)
File "<string>", line 1, in <lambda>
File "/home/philippe/dev/sqlalchemy/./test/lib/testing.py", line 112,
in decorate
return fn(*args, **kw)
File "/home/philippe/dev/sqlalchemy/./test/engine/test_ddlevents.py",
line 481, in test_platform_escape
DDL("select 'foo%something'" + default_from)
File "/home/philippe/dev/sqlalchemy/./lib/sqlalchemy/engine/base.py",
line 3056, in scalar
row = self.first()
File "/home/philippe/dev/sqlalchemy/./lib/sqlalchemy/engine/base.py",
line 3039, in first
self.cursor, self.context)
File "/home/philippe/dev/sqlalchemy/./lib/sqlalchemy/engine/base.py",
line 3035, in first
row = self._fetchone_impl()
File "/home/philippe/dev/sqlalchemy/./lib/sqlalchemy/engine/base.py",
line 2928, in _fetchone_impl
return self.cursor.fetchone()
ProgrammingError: (ProgrammingError) (-504, 'fetch: \n Dynamic SQL
Error\n SQL error code = -504\n Invalid cursor reference\n Cursor is
not open') None None


I don't understand this sqlalchemy problem
why the cursor is not open ?

it seems that it close the connection, not only the transaction
My sqlalchemy code knowledge is near None,
I have to investigate


By the way, I think we can improve firebird dialect in sqlachemy, even
with kinterbasdb