MySQL报错【innoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED】

Caused by: java.sql.BatchUpdateException: 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

posted @ 2012-12-06 10:53  IT一族  阅读(2444)  评论(0编辑  收藏  举报