Changeset 2821 for pykota/trunk/pykota/storages

Timestamp:

03/29/06 08:48:19 (18 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:

• pykota/trunk/pykota/storages/mysqlstorage.py (modified) (1 diff)

pykota/trunk/pykota/storages/mysqlstorage.py

@@ -50 +50 @@
         self.database.autocommit(1)
         self.cursor = self.database.cursor()
+        self.cursor.execute("SET TRANSACTION ISOLATION LEVEL READ COMMITTED;") # Same as PostgreSQL and Oracle's default
         self.closed = 0
         self.tool.logdebug("Database opened (host=%s, port=%s, dbname=%s, user=%s)" % (host, port, dbname, user))