From f76a39d54ec04e373a0e53865a00402a8d3f2143 Mon Sep 17 00:00:00 2001
From: Marco Zanon <info@marcozanon.com>
Date: Thu, 26 Jan 2012 22:33:39 +0000
Subject: [PATCH] Fixed auto-commit modes and transaction isolation levels.

---
 src/java/com/marcozanon/macaco/sql/MSqlConnection.java | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/src/java/com/marcozanon/macaco/sql/MSqlConnection.java b/src/java/com/marcozanon/macaco/sql/MSqlConnection.java
index 3b5779b..4ade2c9 100644
--- a/src/java/com/marcozanon/macaco/sql/MSqlConnection.java
+++ b/src/java/com/marcozanon/macaco/sql/MSqlConnection.java
@@ -166,6 +166,7 @@ public class MSqlConnection extends MObject {
             throw new MTransactionSqlException("Nested transactions not allowed.");
         }
         try {
+            this.getConnectionReference().setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
             this.getConnectionReference().setAutoCommit(false);
             this.setTransactionStatus(MSqlConnection.TransactionStatus.SUCCESSFUL);
         }
@@ -180,6 +181,7 @@ public class MSqlConnection extends MObject {
         }
         try {
             this.getConnectionReference().rollback();
+            this.getConnectionReference().setAutoCommit(true);
             this.setTransactionStatus(MSqlConnection.TransactionStatus.CLOSED);
         }
         catch (SQLException exception) {
@@ -193,6 +195,7 @@ public class MSqlConnection extends MObject {
             case SUCCESSFUL:
                 try {
                     this.getConnectionReference().commit();
+                    this.getConnectionReference().setAutoCommit(true);
                     this.setTransactionStatus(MSqlConnection.TransactionStatus.CLOSED);
                     return MSqlConnection.TransactionStatus.SUCCESSFUL;
                 }
-- 
2.30.2