Isolation level with transtion

[sapkal-manish]

If I have decided to use "beginTransaction" in my code, How to set isolation level for the transaction?

Here is my code :

pool.getConnection(function(err, connection) {
   if (err) {
       //log error to file
       return callback(err, null);
   }
   else {
       connection.beginTransaction(function(err) {
            if (err) { return callback(err, null); }
            connection.query({ 'sql' : query, 'timeout': timeout}, function(err, rows, fields) {
                 connection.release(); //send back to pool
                 if (err) {
                    connection.rollback(function() {
                        //log error to file
                        return callback(err, null);
                    })
                 }
                connection.commit(function(err) {
                    if (err) {
                        connection.rollback(function() {
                            self.delParams(aParam);
                            return callback(err, null);
                        });
                    }
                    return callback && callback(null, rows);
                });
            })
       })
   }
}) 

Now how to set isolation level like 'read commit' in my case? Do you have some example?

[sidorares]

beginTransaction method is just a wrapper for "begin transaction" sql query (as well as commit and rollback methods). You can set isolation level with corresponding sqls: http://dev.mysql.com/doc/refman/5.0/en/set-transaction.html

connection.query('SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED', function(err) {
   // ...
});

see also http://stackoverflow.com/questions/7937472/set-transaction-isolation-level-of-mysql