Cause: 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.
解决办法是:
先登录sql: mysql -uroot -p
再将BINLOG_FORMAT设置成MIXED即可:SET GLOBAL BINLOG_FORMAT = MIXED;