mysql sqlalchemy mysql isolation error

Question

How to set isolation level in sqlalchemy pool configuration. I get the following error when i try to set it as paramaeter in create_engine(...)

File "build/bdist.linux-i686/egg/sqlalchemy/engine/__init__.py", line 321, in create_engine
File "build/bdist.linux-i686/egg/sqlalchemy/engine/strategies.py", line 141, in create
TypeError: Invalid argument(s) 'isolation_level' sent to create_engine(), using configuration  
MySQLDialect_mysqldb/QueuePool/Engine

Will you please provide some code which create the error. Because isolation_level is not available for all database. — NPatel
– NPatel, Commented Feb 29, 2012 at 5:00

NPatel · Accepted Answer · 2012-02-29 09:04:00Z

1

Which version of sqlalchemy do you have because this functionality for mysql is added in 0.7.6.

answered Feb 29, 2012 at 9:04

NPatel

21.4k17 gold badges104 silver badges166 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:16:21Z

1

Like explained in this answer, you can achieve the same result by directly issuing the SQL command to set the isolation level. In case of SQL Server, you could do:

query = 'SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED'
session.connection().connection.execute(query)

edited May 23, 2017 at 12:16

CommunityBot

11 silver badge

answered Jul 18, 2016 at 13:52

Mahdi

1,9121 gold badge22 silver badges38 bronze badges

Comments

Ashish · Accepted Answer · 2012-02-29 16:11:23Z

0

'isolation_level' parameter is passed as one of the argument to create_engine method

Michael Bayer replied on the SQLAlchemy forum : it's the development version. for the moment you can get it like this: hg.sqlalchemy.org/sqlalchemy/archive/default.tar.gz

This solves the problem.

answered Feb 29, 2012 at 16:11

Ashish

8512 gold badges12 silver badges28 bronze badges

Collectives™ on Stack Overflow

mysql sqlalchemy mysql isolation error

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related