Changeset 2821

Show
Ignore:
Timestamp:
03/29/06 08:48:19 (17 years ago)
Author:
jerome
Message:

Changed the transaction isolation level to READ COMMITTED for MySQL,
since it is the default for both PostgreSQL and Oracle, which looks
much saner to me...

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • pykota/trunk/pykota/storages/mysqlstorage.py

    r2773 r2821  
    5050        self.database.autocommit(1) 
    5151        self.cursor = self.database.cursor() 
     52        self.cursor.execute("SET TRANSACTION ISOLATION LEVEL READ COMMITTED;") # Same as PostgreSQL and Oracle's default 
    5253        self.closed = 0 
    5354        self.tool.logdebug("Database opened (host=%s, port=%s, dbname=%s, user=%s)" % (host, port, dbname, user))