[sqlalchemy] [MySQL] Checking if commit() is available

[Andreas Jung]

is there a way to determine if the underlying MySQL DB is able to perform



Andreas
--------------

a commit() operation? The following code fails (likely because the underlying MySQL db is pretty old, V3ish).

dsn = 'mysql://....'
e = create_engine(dsn)
c=e.connect()
t = c.begin()
t.commit()

Traceback (most recent call last):
 File "<stdin>", line 1, in ?


--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535
Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK
------------------------------------------------------------------------
E-Publishing, Python, Zope & Plone development, Consulting

File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 675, in commit File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 488, in _commit_impl sqlalchemy.exceptions.SQLError: (ProgrammingError) (1064, "You have an error in your SQL syntax near 'commit' at line 1") None None

pgpVDItFEqcMO.pgp
Description: PGP signature