降低mysql交易隔離等級

標籤：

　　測試代碼的時候實驗了下降低事物隔離等級：

            Connection conn = null;            try {                conn = DBUtils.getConnection();                conn.setAutoCommit(false);                conn.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
　　　　　　　　............

　　然而，報錯了

java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine 
limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

　　於是看了下BINLOG_FORMAT ： 

　　

　　於是：

　　

　　

　　這樣就可以了，或者據說換MIXED模式也可以，不過沒測試。

降低mysql交易隔離等級